Populate calendar and summary

HI all

I'm looking through various threads, but thought i'd post - in case anyone sees a better way for me to get what i'm after.

I'm needing to create a register of leave - each site (location) will have their own register - but then the senior leadership team needs an overall look at the leave.

The Senior team - don't necessarily need names, however they do need to know a summary of how much leave is taken at each site by day / week / month.


On the attached - can the datatable automatically populate details into the LeaveCal2 tab?

I'm trying to future proof this, hence asking before going too much further - as i'm sure once i get this working the management team will want more details added!