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 ...