use power query file in excel 2013 without power query add in??

[jiddings]

I put together a Excel 2016 spreadsheet using Power Query that brings in data from 6 different workbooks.
Unknown to me, the file will be used with Excel 2013 without Power Query add-in installed.
Will the file still work, with 2013, without Power Query add-in installed?
If not, what can be done short of installing Power Query add-in as it is a corporate (not personal) computer?

 

[RoryA]

You won't be able to refresh the data without Power Query.

 

[jiddings]

I have just learned that corporate IT department will not allow installation of Power Query for Excel 2013.
I have been looking at using Microsoft Query to do what I was able to do with Power Query.
I know very little about Microsoft Query & SQL.
I have 7 different user workbook files each with one worksheet that I need to bring into one Excel workbook sheet summary file.
Is there a way to write Excel MS Query to bring in the 7 different worksheet files data into one Excel summary sheet file and be able to refresh the summary file on a regular basis??
I have found postings on how to access multiple worksheets in one workbook file, but I stumped on how to access 7 different workbook files, again using MS Query.
Any help / guidance with how I can accomplish my task would be mosy greatly appreciated.