If you enter your sheet names in an unused column or new worksheet you can use
the INDIRECT Function to refer to them.

Assume list of sheetnames in Column X from X1:X10

In Summary sheet A3 enter this formula then drag/copy down.

=INDIRECT(X1 & "!$J$5")

On another sheet would be =INDIRECT(Sheetname!X1 & "!$J$5")


Gord Dibben Excel MVP

On 12 Jan 2005 09:21:48 -0800, "jm" wrote:

I have a workbook with sheets named, Summary, 8jan, 15jan, 22jan,
etc... In 'Summary' A3 I have ='8jan$j$5' I would like some way if
possible to inrement A4 and so on automaticaly to the next sheet in
line. So A4 would read ='15jan$j$5' since 15jan is the next sheet. I
assume this may be easier to do if the sheet names use numbers like
0108, 0115 or something, if thats is required then thats

So is there a way to go about doing this?
Thanks for any help you guys can provide.