I have an application where I need to update cell B5 in Sheet 1 with a cell
value from a specific cell (C4) on Sheet 2. The issue is that in this
instance, I need to be able to select Row 4 in Sheet 2 and insert a new row
each month, so that I can record new data in Row 4 for the current month. I
thought that by making the cell reference in Sheet 1 absoute ($B$5) the
current value in Sheet 2, C4 would always be captured. In fact what happens
is that when I select Row 4, Sheet 2 and insert a new row, the $B$5,Sheet 1
cell reference changes to $B$6,Sheet 1.

How can I make sure that the cell reference in Sheet 1 remains absolute with
respect to capturing the value in C4, Sheet 2 when a new line in Sheet 2 is
inserted?

Thanks for any help you can provide.

John