You're very welcome - glad it helped, and appreciate the feedback.

Regards
Ken.................


"the-jackal" wrote in message
...

Thank you ever so much. This has really helped.

Thank you both.

Ken Wright Wrote:
Assuming your sheet names start in cell A1, then in B1 put this and
then
copy down:-

=INDIRECT(A1&"!B5")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"the-jackal" wrote in message
...

What i am trying to do is copy the same cell from about 50 pages
within
the same workbook into a column.

ie

Column A Names all the pages 001-50
Column B Has data from Cell B5 on every page.

I have used ='001'!B5 which works fine but i cant seem to copy it
down
the list. All it changes is the cell. I want the Cell to stay the
same
but the page to change.


--
the-jackal


--
the-jackal