Consolidate calendar inputs into a master sheet

[Linki]

Hi all

I realize there are multiple similar threads here, but I simply don't have the skills to adjust their solutions to my scenario. I hope that is okay.
I will try to detail what I am after as good as I can, I hope it will contain all the information needed.

Context:

• I have an excel file to record vacation, sick leave, etc.. It is in a manual calendar setup (the calendar is not dynamic, its static, as I didn't know how to make a dynamic calendar).
• Each person has a sheet only visible to that person (there's a code that matches sheet name with email account name - we use O365). These sheets should then feed into a master sheet, where I can have an overview of the sick leave etc.
• Each personal sheet is identical, everything is locked except for the calendar days where select values can be chosen (mentioning this because I dont know if that could be a way to specify data ranges, as there are 12 ranges for each year to specify otherwise)
• Also, if relevant knowledge, for some ancient reason, a vacation year in Denmark from a "government vacation system" perspective starts in September, i.e., September 2023 - August 2024

If I had had just 1 sheet to sync data from, my solution would have been something like:
Where the person name matches + the month / year matches insert the value of field range.

Here is a snippet from the master sheet:

Similarly a snippet from an individuals source sheet:

So to sum up, I would have about 15 of the sourcesheets, that should feed in to the master sheet, meaning each month has 15 rows for 15 people (in the example I just have 3 persons)

Hope someone is able to help me out with this
Thank you in advance, and please let me know if I am missing essential details.

 

[Linki]

Realized my snippet of the source sheet did not show the columns and ranges, sorry about that.