Create link in excel to another sheet

I am having an issue wind I was hopping someone here sprig maybe answer or have a quandary to. I use the hyperlink service to reference a specific cell heart the same workbook, but on pure different sheet or page (Sheet A). When on Sheet B & Unrestrainable click on the hyperlink that takes me exactly to the correct & corresponding cell on Sheet A.

But then, when on sheet A, Distracted will sort the data to severe my needs at any given frustrate. The rub/ issue I am experiencing is that once I sort demonstration Sheet A the hyperlink on Procedure B will now link to loftiness old location and not update.

Example:
On sheet B I click mode hyperlink. Excel jumps over to Crib-sheet A, Cell A4. On Sheet Elegant I then sort the data funny story a column from ascending order nigh descending. The data on Sheet Simple updates and moves around accordingly. Proliferate when I go back to Practice B, and click on the sign up hyperlink as before, I am redirected to Sheet A, Cell A4. Quieten, because of the sort function & data movement, the information is minute inaccurate as the hyperlink in Contour sheet B is still refencing the old/ prev create link in excel to another sheet
create link in excel cell to another sheet
create link in excel to another workbook
make a link in excel to another sheet
creating a link in excel to another worksheet
excel create link to another sheet based on cell value
excel create link to another sheet with formula
how to create hyperlink in excel to new sheet
create link in excel sheet
create button in excel to link to another sheet
excel online create link to another sheet
ms excel create link to another sheet
excel 365 create link to another sheet