Hi
I can't open your examples so I'm presuming that the following is (or could be) the case:
each shop has its own identifier (name or number) and that the data within identifies the manager.
that the spreadsheet arrives in a common folder (either automatically or saved from an e-mail, etc)
I'd write a macro to import the data to control spreadsheet, archive the shop spreadsheet, and create the CEO's summary.
regards, Neil