I have a very simple linked formula ( i.e. =personnel!C1 ) which I
use on multiple sheets to reference the "main" sheet titled personnel
and cell reference C1.
( lets title the sheets for simplicity 1) Personnel 2) Task 3)
Info )

If I modify the contents of personnel!C1 -- all sheets are modified as
well.

But if I sort the personnel sheet - the adjacent sheet ( sheet Task)
will adjust the formula to reference the new sorted position - but
reference is not updated in the next sheet ( sheet Info )?

I have tried multiple processes using relative/absolute addressing but
have been unable to get sheets Task AND Info to update.

Can anyone assist?

thank you !!!