I have workbook A and B. I want to hyperlink cell B2 (workbook B) to cell B132 (workbook A). This I can do.

I want to hyperlink those cells together and have them stay paired so that if I sort either worksheet, the cells stay paired. In otherwords, if B132 becomes B145, I want the link in B2 to now take me to B145.

Can this be accomplished?