I've got it.

For every sheet, I need to make a formula:
=VLOOKUP((TODAY()-1),$A$2:$C$30, 2) for today minus 1.

Next cell:
=VLOOKUP((TODAY()-2),$A$2:$C$30, 2) for today minus 2

and so on until today minus 12.

I then get the sum of the 12 cells and wah lah, I've got the hour
worked on one summary sheet. THANKS...


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=495556