link worksheet to folder destination containing changing workbook

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

Please Login or Register  to view this content.

Any thoughts on this working?

Looks like I'll just have to change the source workbook and update the links.