I am working on a document in Excel that contains several tabs. I
have some cells reading from cells on other tabs. For instance, on
tab 1 in cell A3 let's say I have "Corie". Then on tab 2 in G3 I have
"=tab1!A3". I hope this is making sense so far.

Anyways, let's say that I add in a new row, bumping cell A3 to cell
A4. Cell G3 in tab 2 automatically knows to update itself. However,
when I use the sort feature, this automatic update does not take
place. In other words, if I sort the information and Cell A3 that
says "Corie" is moved to A9, cell G3 will continue to read from A3.
Is there a way I can tell it to automatically update itself when I
sort? Thanks for your help, Corie