Referencing worksheet issue
 

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

Referencing worksheet issue
 

Starting in A1:
=indirect("'" & row() & "'!a1")

(or anything that evaluates to 1 in that middle portion:

=indirect("'" & row(a3)-2 & "'!a1")



Keven Jeffery wrote:

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

--

Dave Peterson