summary page of many worksheets
 

How can I summarize the input values of one cell in many worksheets, other
than referencing them individually. I.e. A summary page listing the values
in all worksheet cell h8, for example.

summary page of many worksheets
 

Use INDIRECT to quickly frame it up ..

List the sheetnames in A2 down, eg in A2: Sheet2
List the cell references in B1 across, eg in B1: H8

Then place in B2: =INDIRECT("'"&$A2&"'!"&B$1)
Copy B2 across/fill down as required to populate the summary
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"frustrated scotstman" wrote:
How can I summarize the input values of one cell in many worksheets, other
than referencing them individually. I.e. A summary page listing the values
in all worksheet cell h8, for example.