Hi,

I hope that someone can help.

Basically I have 128 worksheets and on sheet one in column A I want to list the values of A1 in each of the sheet so cell A1 reads sheet1!A1 and then sheet2!A1 etc all the way down, i can do this manually but it takes along time is there a formula that I can put in or a way to copy the cell down, that changes the sheet name and not the cell name.

THank you in advance

Julie