Merging tables in

I have timesheets recording time spent for each client. Although I enter the data on the individual sheets in a table, I want Excel 2007 to put all the data onto a separate sheet (say Sheet 1), so that when I update the timesheet for a client, it will automatically update Sheet 1 with all the information in the tables for each indivdual client. The entries for each cleint are similar and standardised.

I am attaching a sample worksheet. Please can anyone help.

John

Couldn't open your file

The file is in 207 .xlsx format

Sorry i'm on XL 2003