hi i reall need help with autofill

[robz]

ok i have a File.. preety big that has tabs like these on the bottom ..
Z1, Z2, Z3, Z4.. all the way too Z979

Now i have a summary sheet in the Fron where i have this in the cell:
=Z1!A1
=Z2!A1
=Z3!A1

...


now is there a way i can auto fill this all way down.. someone pleas
help.. i need to get this done than

 

[Bernie Deitrick]

Rob,

In a cell in row 1, enter the formula

=INDIRECT("Z"&ROW()&"!A1")

and fill down to row 979, as far as you need.

If you don't want to start in row 1, change ROW() to ROW() - X, where X is
the startuing row less 1.

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
see your other post