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.

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.