I have a formula that I wrote up and it works great. the formula is dragged
down multiple cells, and the cell references update accordingly.

My problem is when I add a new row, the cell references update again. for
example, if I add a new row between 10 and 11, anything referencing the old
11 row would automatically change to reference 12.

I tried using indirect() but then when i drag the formula down the cells
don't update the references. (which is also neccesary)

For example, if cell B11 is =A12, I should be able to drag it down to B12
and it should equal =A13. also, if I add a new row in between, all
references to A12 should remain =A12 and not change to =A13.

Any ideas?

Thanks!