Yes, I have played with it. Unfortunately, the presentation is important, as we have 30 managers who look at this sheet daily and it is updated daily by myself, but could move to someone else.
Each month needs to be separated, and each instance of an absent an what it was for needs to stand out so we can see patterns immediately. The employee list changes daily as do the absences.

We are set on the design, unless you can show a pivot table that updates how I have it now, and retains the visual style. Even if I were to use a Pivot table, I still need to lookup each individual absence for every day of the year for up to 1500 employees which gets posted into the monthly tabs, which already has codes in them to make the data compatible with the Vlookups and the information we want to show.