Dynamic source data in QUERY connections

I have a sheet containing a data connection, created in Microsoft Query - importing non-null cells from one workbook to another. The connection string looks like:

DSN=Excel Files;DBQ=C:\Users\Glenn\Desktop\Source.xlsx;DefaultDir=C:\Users\Glenn\Desktop;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;

The Command Text also specifies the source file:

FROM `C:\Users\Glenn\Desktop\Source.xlsx`.`'1# Copy-Paste Raw$'` `'1# Copy-Paste Raw$'` etc...

Is there anything I can do to use a different workbook (e.g. "second source" in a cell representing "second source.xlsx" ) in an entry in a worksheet cell to replace the filename in the string & the command text?

OK... so what idiot-proof alternatives to ODBC can I use?