I'm not looking for a specific solution, just information on whether or not
this is possible, and if so, some general leads on what I'd need to learn
more about in order to develop and implement.

I have a VBA macro that grabs appointment data
(time/date/duration/subject/etc). As an individual user, it only pulls this
information from my calendar.

We are considering a project where employees would start using custom labels
to document their time on different projects, and ideally we would be able to
pull all of that data at once (not require each user to pull their own
summary data). In my mind, that means someone with some level of IT
administrative access who can access all calendars to pull this data - even
if the individual users have not specifically shared their calendars.

Has anyone pulled data at this aggregate level before, and if so, what are
the major stumbling blocks I should look out for, and what would I need to
learn more about to adapt VBA code from use at an individual level up to
something usable by an IT administrator to pull all calendars?

Thank you,
Keith