Auto fill for sheet names

Hi All,
I am trying to figure out how to reference cells on other sheets and be able to autofill the formula. I am using ='01-07 Sep 2014'!$S$8 at the moment, but this just autofills the cell reference.
Is there a way of autofilling so it takes the next sheet rather than cell? I have tried using INDIRECT function but I haven't had any luck with it.

thanks

Leigh

Do you have a workbook you could attach for what you want? The Indirect will probably be your best bet once you wrap your head around the syntax.

Hi.

All you need to do is to delete your dollar signs. $

Please Login or Register  to view this content.

Hi,
thanks you all for your replies, I have attached an example spreadsheet to help explain what I am trying to achieve.

regards

Leigh

Please see attached for an example of the INDIRECT method. Note, I cheated a bit by altering the labels to match the sheet names (you could also get the same effect by altering the sheet names to match the labels). Leaving both sides of it unchanged would have led to some gnarly conversion formulas.

Hi Yogi,
thats worked a treat, I did have the syntax wrong when I tried it.
thats a lot
regards
Leigh

Sorry about the delay

This formula works too:-

Please Login or Register  to view this content.