I have a sheet in which one cell refers to cell in 2nd sheet. Can I write
the formula in such a way that even if the cell in the 2nd sheet moves with a
sort, the cell in the 1st sheet will follow that change and still pick up the
right information?

Ex:
Sheet 1: C2 starts out =Sheet2!E2754

Then someone sorts Sheet 2 so E2754 is now E415.

So, what I want is that when that sort happens Sheet 1 changes C2 to
=Sheet2!E415.

Make sense?

Thanks so much!