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

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