Input data from dynamic number of files into identically named Excel sheets

[flvn]

I have a scenario where I will have a variable number of files in a directory which all follow a very specific naming convention, as per below:

'Lever 1Query1'

'Lever 1Query2'

'Lever 1Query3'

'Lever 2Query1'

'Lever 2Query2' 

and so on.

All of these files have the same structure and I want to input the data into an Excel Spreadsheet which has individual sheets with the same names.

That would mean that data from file 'Lever 1Query1' goes into the output Excel file, in the sheet called 'Lever 1Query1'

Is there any way I could do this with Alteryx?

[Qiu]

@flvn 

This is a classic query and just giving a sample.