Keep Reference to a cell after Row or Column is inserted/deleted

I've been using VBA to inset and delete rows.

Problem is, I've been referring to these rows in other places in the spreadsheets

When Inset a row, the reference automatically shifts down

Eg.

Cell A2 in Sheet2 is referencing to Cell A2 in Sheet1

When I insert a row between Row 1 and Row 2 in Sheet1, Cell A2 in Sheet2 now references to cell A3

I want it to keep reference cell A2


This is similar with delete. If the VBA deleted this same row 2 in Sheet1, Cell A2 in Sheet2 read #REF error and the formula changes to #REF where-ever the original Sheet1.A2 is referenced.

I want to be able to keep Reference to the new Cell Sheet1.A2.

Thank you