index Match to reformat data

I didnt even think about the possibility of a macro:

@ Jb, it appears as though Stanleys macro performs the way I wanted. No information needed for days when no production is worked.

Now a new issue: There are several worksheets that I will have to sort through in each workbook as shown here in this example:

Tracker, Tracker2, Tracker 3.

However the names are not Tracker in Real Life, How can I change the macro to include several worksheets?

thanks for you assistance.