One other angle to your post ...

If you have identically structured source sheets, you could use INDIRECT to
easily "summarize" it on a separate sheet

Here's an illustration tailored to your posting:
http://www.freefilehosting.net/download/3bl31
Summarizing using indirect.xls

In the summary sheet,

List the sheetnames in A3 down.
These must match exactly with what's on the tabs, except for case

In B2 across, list the labels: Name, OverTime, Sick
In B1 across, list the corresponding cell refs: E5, D45, J46

Place in B3:
=IF(COUNTA($A3,B$1)<2,"",INDIRECT("'"&$A3&"'!"&B$1 ))
Copy B3 across/fill down to populate the table as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Helen B" wrote:
I want to create a summary worksheet that shows the data in the same cells on
all the other worksheets in the workbook.

I have 30 individual worksheets, one for each employee in the department,
detailing overtime absence etc for the month. On sheet 1 I want to create a
list of all employees and a total of their overtime etc. ie On each
individual sheet = Employee name E5, overtime D45, sick J46 etc. On summary
sheet a list of Employee name E5, overtime D45, sick J46 etc for each
individual.

I have tried "fill series" but there is no option for series = next worksheet.

Hope this all makes sence to somebody.

Helen