Timesheet Summary Page - Complicated

Hi,

I have a shared Timesheet workbook that each employee from various departments uses to record their time spent on a customer contract. What I need to be able to get a summary of hours worked on a contract at any time on a summary sheet.

I have attached an example. On the example are 3 employee time sheets and then there are 2 summary sheets where I have hand crafted examples what I would like my summary pages to look like.

I would imagine this is quite complex but any helo you can give would be much appreciated so thanks in advance.

One more thing to consider is that new contracts are added daily so the summary needs dynamically account for them.

Thanks.

______________bump____________