Convert Text Data Queries to use Excel file as source file

[bricol13]

I have various workbooks that I've used for years to import data from .csv (text) files that were downloaded from my company system. These were run using buttons and Querytable Refresh macros, and worked beautifully, omitting unwanted data, maintaining my formats and updating/inserting formula's alongside the imported data..
Now in their wisdom, my company has elected to make all exports from the system .xlsx files to make it "easier" for people to work with the data...

I am trying to find a way to use these xlsx workbooks in the same way as I used to use the .csv data but have had no joy. Currently I am having to open each file & then save it again as a comma seperated values (.csv) file in order to refresh my query tables. Can anyone help?Basically, I need to pull selected data from a another excel workbook (source) into a table in my destination workbook, retaining the formats & column widths set in the destination workbook, as well as adding or deleting adjoining formula