Consolidate workbooks

Hi all

Need some help. There is now a requirement for my team to complete timesheets. Something like the attached. I have 2 sheets on there but that will actually be 2 workbooks, as an example

The requirement is for each individual to complete their timesheet and drop in a folder. Our manager will then see 15 timesheets in this folder. He would then need to consolidate the timesheets into ONE workbook and ONE worksheet.

They want to do some analysis etc so would need a total of all timesheets.

However if you look at the timesheet - each could be different depending on how many clients that person has worked for that week. Person 1 may have 5 clients that period whilst Person 2 may have just the one.

Any idea's how this can be achieved please?

Thanks