I am not an advanced user of this product and this question I think has a
simple answer, but all my research does not find a solution.

What I would like to achieve;
I am attempting to get a cell on Sheet 1 to read the contents of a
particular Row/Column cell on Sheet 2 with out it being dependant on the
particular cell.

Discussion;
This might appear simple to some but my ending condition is what defeats me.
I want the Sheet1 cell to only read from for example Row1/Column1 of sheet2.
So for example if I insert a column later into the first column location on
Sheet2 the original cell that was targeted for reading effectively is moved
to column2. Now under normal formulas the sheet1 cell will follow the
original cell to its new location and will now read from Row1/Column2.

However I actually want the Sheet1 cell to only ever read the contents from
Row1/Column1 regardless of what formatting or insertions occurs on Sheet2.

This is where my efforts collapse.

I would greatly appreciate if any one has any suggestions on how to achieve
this. I have an feeling the answer is simple and I am just not seeing it.

Thanks