Excel file DSN Connection to itself

I'm trying to figure out a way to query multiple tabs and aggregate the data into one tab. I'm trying to avoid using VBA so that someone doesn't have to support my work, so instead I've been able to use the import data feature in excel to connect the sheet to itself. The problem is, if i make a copy of the file, it is always referencing the original file. My excel file is saved in xlsx format.

The original code is

Please Login or Register  to view this content.

I may have to change filename or change file directory and I cannot find a way of automatically update query


Any hint to solve this issue?

Kind regards,
Manuel