Best way would be to sum them in a nominated cell on each worksheet, lets
say B2, B3, etc and then sum them like

=SUM(Sheet1:Sheet26!B2)

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NetMax" wrote in message
. ..
Each workbook sheet has payroll records per individual for the entire
year (regular hours, overtime, holiday etc).

I want a summary sheet to display the relevant data (ie: sums of regular
hours, sick days etc) of the payperiod entered (1 of 26) for each
employee.

So the clerk (me) enters a payroll period, and sees that data for each
employee.

Seems simply enough, and there is probably more than one way to do it,
but the help files have only frustrated me so far.


TIA
--
NetMax