Holiday Time Off to Appy to Each Employee

Hello There,
I have a table where employees will enter their time off through out the year. Instead of having them enter the holiday time, I would like to have the holidays applied to each employee so when I refresh the pivot table it will show the true amount of time off. Attached is an example. The red font is the data I would like to be "canned" for each auditor