Hyperlinks

I am working on a spreadsheet which contains multiple hyperlinks to other workbooks. However, whenever I need to sort my spreadsheet the hyperlinks break. ie I have columns A, B, C, D & E. The hyperlinks are held in cells under column D but if I need to sort by column B the hyperlinks do not work.

What is interesting is that they work (1) when I convert back to the original layout of the spreadsheet and (2) they work in the cell they were assigned to ie. if originally the hyperlink was in cell D3 and I sort the information, the hyperlink will still work in cell D3 but not in the cell I expect it to when sorted. Can anyone advise on how to address this?

Many thanks