Hmmm... I also have cells that reference other sheets (you call them tabs) so
I tried inserting some rows and my reference changed from D38 to D40. It
knew I added 2 rows and made the appropriate change. Continued to reference
the correct information. The exact wording of that cell is ='Mar 07'!D38

Mar 07 is the sheet it is referencing. Don't know if it makes a difference
but does your sheet name have the ' around it? You don't show them in your
example below. Otherwise, I dunno what the error is as it works on mine.

Good luck.

"Chris" wrote:

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