Formual to popualte data based on date

Hello:


Please refer to attached file.

I have Weekly hours worked for employees.
The name of the employees in in Row2.
Week Start and end date is in column B and C and employees hours worked a give week is in column H:O.

i need to populate the data in Grid shown in Cell X17:AB21.
In cell AA16, i would like the end date of the payroll ( this date will be the last paycheck end period).
For Example today is 8/26/2014 so AA16 would be 8/21/2014.
Now based on this day, i would like to populate hours for each employees in cell AB19 thru AB21.
For convenience i have manually entered the data.

I would like the formula to do this automatically.

Let me know if you have any questions.
Thanks.