Worksheet 1(WS1) has multiple rows and columns. Worksheet 2(WS2) is to display some of the columns and all of the rows from 1. The issue I have is that during my process, some of the rows from A are removed and placed in another location.
When using =A2 in WS2 the information looks great, the problem comes after removing/deleting row 2 in WS1 and having the remaining rows shift up. I then get the #REF! error in WS2.