Combine different Yearly Plannings into a Weekly Overview

Hello Excel Pros.

I came to a problem with my most used Excel sheet.
I work as kind of a manager in promotion business and we have different locations in contract.
So for every location we have an own excel sheet, with a load of different dates which this locations are 'activated' for promoting.

For example,
Right now I have something like 5 different locations, and about 20 promoters working for us.

Its always pretty hard to plan my promoters, because I have to check sheet for sheet, if someone is already working on that day or not.

Now I would like to have an additional sheet.
This sheet should read all the other sheets, and then combine then all the activations together into a weekly overview.
In this weekly overwiew, I want to add our employees names, to send it out as our planning. The names don't have to be copied back to the other sheets.

I hope you understand my problem. If it's to complicate I could uploade a 'fake' excel, to show you what I'm talking about. I'm not allowed to show the original datas.

Best regards,
Simon