Auto Extraction of Data

[Offeror]

Hi,
Im having to work with a workbook containing approx. 70 worksheets, and currently i have to prepare a report by manually looking into all individual sheets. I need an automation so that the report is generated everyday automatically.

Each worksheet is for separate employee, and contains rows for each day in the month, say January, so there are 31 rows. I do daily entry in one row, and the same for all worksheets in a particular day. if in a day a row remains blank, i prepare a report of such employees whose entry was not made.

Can data be extracted in such a way, that a macro evaulated each sheet for the criteria that the row is blank, and if yes it extracts the name of all such employees from all relevant sheets to another workbook?

im attaching a basic file to show the entry, the highlighted row represents the day for which i will prepare the report based on it being blank for an employee. THanks a lot, i need this badly.