Pull down and sheet number increase and cell stay the same

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