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