INDIRECT holds the key for you

In your summary sheet,
Assume your source sheetnames are listed in A2 down
(Sheetnames must match exactly with what's on the tabs, except for case)
Assume the key cell refs to be extracted from each source sheet
are listed in B1 across, eg: B2, E5, etc
Put in B2: =INDIRECT("'"&$A2&"'!"&B$1)
Copy B2 across/fill down to populate the required extracts in one fell swoop

Celebrate your success, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Denis" wrote:
I have the same absolute cell reference across several named worksheets in a
workbook. I wish to summarise this data in a new "summary sheet". Does anyone
know how to increment the worksheets in a formula, so that when I use the
"fill handle" in the summary sheet it will bring in the data from each of the
worksheets.

Many Thanks