Excel: how to sort a set of data on another worksheet by reference

• Copy a range from Sheet1 to Sheet2, but do Paste Special and choose link
• Enable developer mode, and create a Macro with the code from this page:
• http://www.mrexcel.com/forum/excel-questions/583935-how-change-relative-values-absolute-mac.html
• Select all the cells you pasted a reference to and run the macro once
• Then select the cells on Sheet2 and sort them - wha la!