Increasing rows in formula by increment of 1 every 3 rows

[2527550]

Hello,
I am searching for help on a formula to increase by increments of 1 in every third row. Needing $C$2 in row G3 and $C$3 in G6 and $C$4 in G9, etc. If I put a number 1 in cell A1 and number 2 in cell A4 and number 3 in cell A7, etc then Excel will fill down for me accurately but the formula is not incrementing properly. I thought the ROW formula could help but I could not write it to work. Help needed. Using Excel 2007.

 

[2527550]

=INDIRECT("C"&ROW(C3)/3+1), This worked for me and I learned tons from the samples. Thank each of you for your help!!

 

[PhatRam32]

=INDIRECT("C"&ROW(C3)/3+1), This worked for me and I learned tons from the samples. Thank each of you for your help!!

What if the data is located on another sheet? How would we reference say Column C from sheet2?

I tried this: =INDIRECT("Sheet!C"&ROW(Sheet!C3)/3+1) but got an error. Trying to do something very similar to this.