I have a workbook with a list of locations. I parse out shared workbooks to respective regional managers. The regional managers enter contractor information and hours worked at each location. I want to reference their hours for each day into my master sheet.
The problem arises when the regional managers sort their lists by some metric - say zip code. The data source location changes and my reference formula only targets the cell.
Is there a way for my reference formula to "follow" the data?
='[Regional Store Locations.xlsx]Sheet1'!A1 is the reference formula im trying to manipulate