index Match to reformat data

I have several trackers that production employees fill out daily, that are in an ugly format for data anaylsis, but is convenient for their daily use.

I was wondering if someone could help me figure out a way to get the information into the format that I would like.

I would like the data to show in columns:

• Dates
• Last Name
• First Name
• Quantity
• Hours
• Avg

I am going to show the workbook, exactly as the Tracker is formatted, then there is an example of the format that I would like to get all the data.
I was thinking, maybe I could have this "Final Format" sheet in each workbook, but I am not sure.

Any ideas would be appreciated.

Thanks,
Staci