In reply to Richard McHugh.

This article doesn't cover the multiple spreadsheet scenario.

For multiple XLSX files, here's what I would suggest:
- Use the Copy Files task to copy the XLSX files from your local source to your SAS session (that task supports wildcards and macro variables).
- Use macro code to iterate over each XLSX file and use PROC IMPORT or LIBNAME XLSX to pull the data into SAS data sets.

Easier said than done, perhaps. But neither PROC IMPORT nor LIBNAME XLSX support filename wildcards natively.