Can I sort data used in formulas on a different workbook?
 

I need to link values/data from one workbook to another, then sort the
original workbook. I can create an = function but once I sort the first
workbook, that value changes. Can I create a funtion that allows the value
to stay with that line item regardless of how I sort it?