Losing References

Hi, Look at the sample below.

Sheet1

A1 = a
A2 = b


Sheet 2

A1 =Sheet1!$A1
A2 =Sheet2!$A2
A3 =Sheet3!$A3
A4 =Sheet4!$A4
A5 =Sheet5!$A5

So, suppose that you want to insert a row between 1 and 2 in the Sheet1. If you look at the Sheet2, the values are not updated. If you try to delete a row in the Sheet1, you lose the reference.

The idea is to have updating the rows in the Sheet2, it doesnt matter if you insert or delete rows in the Sheet1.

One way to solve it, it would be to create MACRO, but in this case, the user needs to click to update the spreadsheet. What I would like to do, it would be the spreadsheet being updated automatically.

Is there a way?

tks.