I manually complete 4 or 5 sheets (some months include 4 weeks, some months stretch to 5 weeks) of weekly staff schedules but want this data to be transposed automatically to a new sheet which will provide an overview of the weekly sheets on a single sheet.
This is a screen capture of one my "weekly sheets" which I input manually:
And this is the "monthly overview" which I want to be completed automatically based on the data in the weekly sheets:
Any help greatly appreciated.
Thank you.
This is a screen capture of one my "weekly sheets" which I input manually:

And this is the "monthly overview" which I want to be completed automatically based on the data in the weekly sheets:

Any help greatly appreciated.
Thank you.