I have the following formula:

=('grow rev - pages'!C6)
=('grow rev - pages'!C7)
=('Grow Revenue - current'!E3)
etc

I want to go through the s/sheet and change the formula in each cell to:

=indirect("'grow rev - pages'!$C$6")

Is there a way of automating this? I have 800 cells that need changing....

Thanks in advance...