Referencing worksheet issue

  • Thread starter Thread starter Keven Jeffery
  • Start date Start date
K

Keven Jeffery

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
 
Starting in A1:
=indirect("'" & row() & "'!a1")

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

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