Reference Column that Auto Changes

[Mcook13]

I have Column A that references another column on another tab.

So I have cell A10 referencing W2 on tab 2. I want column A to change automatically when Column W on tab 2 changes (i.e.- a row is deleted) and not display any errors such as #REF . I understand why it does that, but I don't know the formula to correct it.


Column A Tab 2
A10 = W2
A11 = W3
A12 = W4
A13 = W5