short cut for copy past w formulas??

[DR, Bob]

I hope I can explain this right.
If Sheet 1 cell 1A were to equal Sheet 2 Cell 1A
I need a quick way to copy that formula so on sheet 1 cell 9A will = sheet
2 cell 2A , sheet 1 row 17 A = Sheet 2 Cell 3A and so on ..
If i do a straight copy past it equals the row on sheet 2 which is no good
to me.. I only have about 300 cells to do so any short cut would help.

Thanks in advance.

 

[Jack Sheet]

In sheet1 cell A1 enter the formula

=OFFSET(Sheet2!$A$1,TRUNC((ROW(A1)-1)/8),0)

Then copy this down to every 8n+1'th row