I am in charge of tracking vacation and sick time for our employees. I have
over 30 people that I made individual spreadsheets for that records these two
categories. Then I have to manually enter their days into another calendar so
that we can compare days off relative to other employees.

Is there a way that when I enter the date and hours into the table, that it
will automatically populate on the calendar or vice versa?