I am trying to use the indirect formula to look at a particular cell on
another worksheet. My formula is - =INDIRECT('Tracking Sheet'!A4). The
result i am getting is #REF. I am inserting new rows in the tracking sheet
but i would like A4 to be the constant.

Hope this makes sense. Can somebody help me please?