I think that Access would be your best bet. You could combine all of your pages in Excel to one table in Access, with all of your fields for date, employee, hours worked, etc., etc., and then you could sort, filter, and arrange the table in a multitude of different ways. Nothing against Excel, but if you know how to use Access, I definitely think that you should give it a shot.
Jenny, in order to do the kind of analyses that
you mentioned you really need to organize your
data into a single columnar list. I strongly
urge you to consult the Excel Help Index topic
for...
1. About using a list as a database
2. Guidelines for creating a list on a worksheet
If I understand you you have a tab for each employee, and 26 columns of data.
The others are correct, but if you feel your way deep into this one.
I would create a "summary sheet", and "Paste Link"("copy" your data, then "paste special", then click on "paste link") all of your data.
Later, you can go back and reorganize.
Then you can create your graphs and such
Gee, I thought mine was the "real answer" : ) (nt)