Pull down and sheet number increase and cell stay the same

Copper Contributor

I would like to be able to drag down and the cel stay the same and the sheet number to increase.
At the moment I use the formula
=sheet1!$G$7
I would like to drag it down and the cell G7 stay the same but in the box below I need the next sheet. I’m having to pull it down and change the sheet number on every cell. Very time consuming :(

 

Any help will be appreciated 

1 Reply

@Vdobson 

That could be like

=INDIRECT("Sheet" & ROW($A1) & "!$G$7" )

and drag it down