Col A is Conditionally formatted to show people that have more than 1 year of service since Hire Date. This is unnecessary as you already have that data in column B Years of Service. Go into Conditional Formatting, Manage Rules, Workbook and delete all the rules then click APPLY then OK. This will get rid of the unnecessary colour coding.

The Blue Button:
Right click on the button (don't left click first just right click anywhere on the blue button). Choose Assign Macro and select and select Plaque3_Click then OK. That will assign the macro to the button.

Col Y appears to be the start of the calculation of the 61 days to get the 3 days Personal and Sick. A calculation like this will give you the number of days since "Anniversary Date". Any value >=61 give 3 days credit. (this is just a guess on my part for this incomplete calculation that is there.)

Formula: copy to clipboard 
=IF(TODAY()-DATE(YEAR(TODAY()),MONTH(A8),DAY(A8))<0,365+TODAY()-DATE(YEAR(TODAY()),MONTH(A8),DAY(A8)),TODAY()-DATE(YEAR(TODAY()),MONTH(A8),DAY(A8)))


You have separate worksheets for VacationHours, PersonalHours, SickHours etc. I think that someone conversant in VBA could have the correct rows blanked on the anniversary dates so that the calculations on the Summary worksheet would be "reset". I'm not conversant in VBA to be able to do that.

It appears to me that VBA is the way to go and a VBA expert should be able help you out with that.