Hello,

I have a workbook with 50 sheets (named 1-50 )and would like to create a
summary sheet that displays the value of a cell (say A1) on each sheet. Is
there some way to force an incremental increase in the sheet number as I
drag a cell downward? I am not familiar with constructing macros, is there a
way to do this without a macro, or with a simple macro a beginner might
construct?

I'd like it to look like the following.

='1'!$A$1
='2'!$A$1
='3'!$A$1
='4'!$A$1
....
='50'!$A$1

Thanks in advance for the assistance,

Keven