You need more than just an automation. You need some roll ups and formulas to support the automation. This is assuming that the two sheets/tabs/tables are linked together.
Have a rollup in the [team members] table that identifies the latest EOD report. Use MAX(values) in the rollup formula. Have a formula field that finds the difference between TODAY() and the latest EOD report. Then trigger off that difference. You may also need to adjust the formulas so that they will reset every day, or the automation will trigger only for the first missed EOD report, and not for consecutive missing reports.