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


"robz " wrote in message
...
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 please
help.. i need to get this done thanx


---
Message posted from http://www.ExcelForum.com/