Timesheet with forumlas and functions

I am trying to create a complex time sheet that eliminates the need for re keying as much as possible. It includes two summary sheets at the beginning of the workbook and has the days of the week following.

The help I need is involving the display of the time entered by a superintendent daily. The information that is entered daily will reproduce for a payroll clerk on the employee summary tab. The individuals hours need to print out on the employee summary sheet by day. One individual may work 8 hours on 8 different items and I need them all to display. I don't fully think I know how to get this to display.

I am attaching the workbook for your use.

Gunner

I redid part of the attachment to make it more clear what I am looking for. I am sorry I didnt do that before. I have put an example into the employee summary tab from sunday's timesheet. That is the type of data I am looking for. The logic behind the sheet is that any timecode can be chosen and I want it to display by worker onto the employee summary sheet.

The range will be the daily time cards from the names to the last line.