Import from multiple files (each workbook contains only one sheet, but the names differ)

[Konkuer]

Hi everyone,

I have 15 excel workbooks located in the same folder, each of them contains only one sheet, but the sheets' names are different.

Is it possible that I batch import all sheets without using directory or macro?

Thanks in advance,

Kk

[atcodedog05]

Hi @Konkuer 

I dont think its possible without using directory and macro. It would only be possible to do without directory and macro if you already have the file full path and sheetname in a list.