Timesheets and Reports

Hello,

I am quite new to Excel and trying to find a way to link a whole list of time-sheets back to a main workbook so that I can print out reports.

Basically I work in a small drafting office. There is me, and 2 draftees. I receive the attached timesheets on a weekly basis, and I was wondering if there was a way to link it back to a main workbook (not yet arranged) so that I can get summaries/reports of the following:

• Number of hours an employee has worked in the week.
• Number of hours an employee has spent on a project
• Number of hours spent on a project by all employees.
• Possibly include the descriptions of work in the project summaries adjacent to the hours spent.

I am not sure if all of the above is possible, and I am quite happy to amend the timesheet to be more user-friendly.....there was no intention of using these timesheets for this purpose, so I have assumed a bit of tweaking will be required.

Any advice will be very much appreciated.

Thanks,
Andy