I have a worksheet that is looking at another worksheet, but when I copy this
data into a third sheet it automatically changes the range for a example one
cell has the formula ='2009'!H9

I want to copy this into another worksheet, it is not going in the same
position on the second worksheet as the first worksheet.

Because I am pasting this a few rows further down the second worksheet I get
the following ='2009'!H15
Where as I need it to be the same.

I could change it manually but I have rows of this for the 52 weeks of the
year.