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.