Time off accrual workbook

I am trying to do a 52 pay period, 50 employee, workbook that summarizes employee timeoff accruals for three different types of time off. This is for an underfunded non-profit so there is no budget. I have created the employee worksheets (dummies) with the simple formulas and rates. I have also, started the summary sheet and linked the cells. However, I cannot complete the last portion so that when the pay day is entered it pulls from the coreect row.