I use a workbook that I download frequently as updates are made. I have created and added a sheet to pull selected data that is included on one of the standard sheets.

Is there some way that I can change the XLOOKUP formulas (example below), or use different formulas, so I do not need to update all the XLOOKUPs every time I copy the sheet into a new workbook? Alternately, is there a way to copy the sheet so it doesn’t reference the old workbook for the lookup? The table names and labels are already in the downloaded workbook. I feel like I should know how to do this, but nothing is coming to mind.

=XLOOKUP(C4,Master_List[Delivery Code],Master_List[Location],"")