I have a list in Worksheet 1, and I link some values to Worksheet 2 by using
='Worksheet1'B1 formula.

When I sort the list in Worksheet 1, the value in the linked cell in
Worksheet 2 changes as well. I want the value to stay the same in Worksheet
2, and the formula updates. Is this possible?