How to hyperlink in document so reference remains valid after a so
 

I would like to reference from a cell on one worksheet to another cell on a
different worksheet on the same workbook so that the reference remain valid
(i.e. goes to the same piece of data) even after the second worksheet is
re-sorted. The default is that the reference goes to the same cell