I believe you wont have any problem doing this. Excel is generally quite good a automatically updating references for you.

For example if you cut cell `A1`

into cell `B1`

then a formula `=A1+A2`

will be updated to `=B1+A2`

for you.

So first try to just cut all the cells in `Sheet 2`

and paste them to the right of you cells in `Sheet 1`

.If it dose have a problem with it, my best advice would be to update the top formula cells manually and drag down the 'auto fill square' to fill the range.

Thirdly you could try this:

Assume you have `X`

columns of data in sheet1.

- In sheet2 insert at least
`X`

New Columns to the left of Column A.
- Check that the formulas still work.
- Copy and paste cells from sheet2 into sheet1.
**The cells should go exactly where they were in the previous sheet.** (i.e. Move cell `Sheet2!X1`

-> `Sheet1!X1`

, this should work because of the cell you have inserted in step 1 means there is no overlap).
- Check that the formulas still work. (They should because they will still be referencing the old data)
- Now find replace in formulas all
`"Sheet2!"`

for `"Sheet1!"`

- Check that the formulas still work.
- You are done :)