GTOTAL!C4 = 205!G4.
GTOTAL!C5 = 205!G5

then on next SH = 206
GTOTAL!D4 = 206!G4
GTOTAL!D5 = 206!G5

and so on

Is this possible? I tried searching and using the codes I find here
and could not make it work. Please help. Thank you.

I use
Cells.Replace What:="OtherSheet!", Replacement:="",
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

after .PasteSpecial