=INDIRECT("'Sheet 1'!R"&1+INT((ROW()-1)/3)&"C"&1+MOD(ROW()-1,3),0)

enter this formula in A1 and copy down. I haven't found a way yet to
increment references the way you want, without using a formula like this.

" wrote:

ok

Spread Sheet 1

A B C
1 1.0 2.0 3.0
2 1.1 2.1 3.1
3 1.2 2.2 3.2
4 1.3 2.3 3.3

Spread Sheet 2

A B C
1 1.0
2 2.0
3 3.0
4 1.1
5 2.1
6 3.1

Spread sheet 1 is the data that I am pulling from and spread sheet 2 is
what I want it to look like. The problem is that when I copy the
A1,2,3 of spread sheet 2, to A456 it wants to reference A4 B4 C4 from
spread sheet 1. What I want it to do is reference A2 B2 C2. Hope this
explains it a little better.