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.