Add Columns without changing calculations

[Okspaghetti]

I have calculations on two different worksheets refering to each other.

I need to add a column in one worksheet but when i do, the calculations on the other no longer matches. (which means i have to change every single code with the additional column.)

Is there a way to add columns to a worksheet without affecting the calculations on the other worksheet?

I hope i have explained this accuratly.

 

[BigC]

How does this occur?
If you're using formulae which include links between the two worksheets, adding a column in one should adjust the cell references in any formula on the other worksheet accordingly!
Can expand your explanation of the problem?