How to summarise 9 sheets into sheet 1

Hi

I am a novice at macro code - have done a couple of small projects. I attach a spreadsheet which might help explain what I am trying to get to. I have manually updated sheet 1 to explain what results I am after but I am looking for the macro to populate this sheet from all the other sheets.

Basically I need 9 payroll processors named as individual sheets to update their work schedules as and when they complete each task from columns A to O. That data needs to feed for each processor into the Full Client list data held on sheet 1.
The idea is to include conditional formating or a macro at the end so as to inform the user/owner of spreadsheet as to what tasks have been completed -say cell colour green and what is outstanding as of todays date - outstanding date cells would be colour coded red.

I appreciate any kind of guidance here
Leanne

Have a try with this macro to aggregate your data:

Please Login or Register  to view this content.