I am trying to auto fill the cell references 'S8' from each of my workbook sheets onto a final summary.
I have tried using the INDIRECT function but am getting a 'REF' error each time. The first sheet is called '01-07 Sep 2014'
Any suggestions would be great.
thanks
Leigh