PLEASE PLEASE HELP ME... i think its autofill .. not sure

[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

 

[Frank Kabel]

Hi
in the first cell enter
=INDIRECT("'Z" & ROW(1:1) & "'!A1")
and copy down

 

[David McRitchie]

With thousands of posting per day in the Excel newsgroups,
no one gets a response within 5 minutes, which is how long
you waited before posting the same question in another group.

Kind of hard to continue with the same question reposted to
other groups, rather than getting better answers you generally
get the same answers but less participation. Please stick
to posting once per question and stick with the thread.

The same people are in many of the Excel newsgroup if they
are not real specialized.
excel, excel.misc, excel.worksheet.functions,
excel.programming
are pretty much frequented and answered by the same people.

Now I made Frank feel bad because he knows he wasted time,
where he could have answered somebody else's questions instead;
and Max, Gord, and myself feel bad because you didn't like our
answers and went and asked same question again elsewhere
did we charge too much. (fortunately we'll recovery shortly)

 

[Frank Kabel]

Hi David

David McRitchie wrote:
[...]

Now I made Frank feel bad because he knows he wasted time,
where he could have answered somebody else's questions instead;
and Max, Gord, and myself feel bad because you didn't like our
answers and went and asked same question again elsewhere
did we charge too much. (fortunately we'll recovery shortly)

hope you have recovered by now ))

Frank

 

[David McRitchie]

Yeah, I'm in the same shape as before.

hope you have recovered by now ))

 

[Debra Dalgleish]

Sorry to hear that! <g>

Yeah, I'm in the same shape as before.