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.