Multiple sheet sorts with links between sheets.

[ericsastud]

Hello, I am dealing with a complex problem that we haven't been able to figure out for years.

Sheet1 has links to Sheet2. If Sheet2 is sorted, Sheet1 no longer points to the same information on Sheet2. The links remain pointed to the same cells as before on Sheet2, but now those cells contain different information. Is there any way to make the cell references to another sheet dynamic?

I have attached an Excel file to better illustrate the problem.