run the attached example

insert 2 new sheets "Sheet3"/"Sheet4"

1. switch to Sheet3
2. type "aaa" into A1 of Sheet3
3. switch to Sheet4
4. type "=Sheet3!A1" into A1 of Sheet4 => cell will show "aaa" referenced from Sheet3 OK
5. switch back to Sheet3
6. insert one column before column A
7. switch again to Sheet4 => the reference in A1 is not updated to "=Sheet3!A1"

if you try the same between the existing sheets "Input" / "Liquidity" it works, and inserting a column will update the reference correctly