Cell Reference don't change on sorting hyperlinks!!

Hello All,

How can i change the cell reference when i sort the data with hyperlink?
For eg :- Below image consist data from A to C.
Cell Reference for hypelink C entered is A3.
When i sort the below Hyperlinks in descending order and C being now in cell A1, Cell reference still shows as A3.
How will it change automatically to A1?
Capture.JPG

Capture1.JPG

Capture2.JPG

Regards
Sid

Thanks for your time mate. Attached is a sample workbook. Now when i sort the data as per descending order cell reference wont change. For eg data is from A to H, Right click on H - edit hyperlink - Type in cell reference A8. On sorting the data, H now being in cell A1 i need to direct this to A1 automatically and not A8.
Hyperlink.xlsx