Employee attendance tracker - viewing all together on a year calendar

Hello all,

I am guilty of using a prefab template from excel, it suits most of my needs except for one of my core requirements,
I refer to an employee attendance record,
I wish to use this and have managed to add in extra bits and pieces as I require, but I also need a sheet that displays all of the data in a long year with all of the employee's down the left so that it can be seen when multiple are on leave at the same time.

because of the nature of the template and its involved functions I have attached a copy of it.
as you will see I have put a bit of an example of a year to view in the sheet named as such at the bottom of what I hope to happen, I wish for all of that to be grabbed from the data that is on the "Employee Leave Tracker" Sheet

In short, I need all the data displayed inside the Calendar view, to consolidate into one long year calendar with all employees colored at once along it in the same color formats as the Calendar view.

Thanks so much for any help, I have been racking my brain but have come up empty.