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 as an XML file, so the connection looks like this:

<Connection>DSN=Excel Files;DBQ=C:\SchedulingXMLTEST\12182007-Schedule.xml;DefaultDir=C:\SchedulingXMLTEST;DriverId=790;MaxBufferSize=2048;</Connection>

I've tried things such as this:

<Connection>DSN=Excel Files;DBQ=12182007-Schedule.xml;DefaultDir=./;DriverId=790;MaxBufferSize=2048;</Connection>

But nothing seems to work and allow for me to make the file reference itself. If you have any ideas, please let me know. Thanks.