I'm having an issue trying to figure this out.
I'm trying to link my worksheet(destination) to a source folder on my desktop which contains a workbook which gets replaced.

The destination worksheet gets auto-filled with info from the workbook in the source folder.
When required I need to delete the workbook in the source folder and replace it with another.
My problem is maintaining the link within the destination worksheet.
My thought is I need the sheet name to change in the formula based on the workbook that gets inserted into the source folder
='C:\Users\Owner\Desktop\source\[IFCCtest.xlsm]order'!$B$15
Any thoughts on this working?