This macro, irrespective of the schema will stack tables on top of each other.
Both tools require the filepath of each sheet to be generated and passed into the macro. This can be done with relative ease within Alteryx.
Use an input tool and from within this browse to your desired excel file. On selection you will recieve a prompt to select a sheet. At the top you will see '<List of Sheet Names>'. Select this option.
In the input tool also select the 'Output File Name as Field' option and change this too 'Full Path'
On running you will receive a two column data stream, one specifies the sheet name and one has the file path. You will get a row for each sheet.
You can then use a formula too to bring these fields together to generate your path which includes the sheet. [FileName]+[Sheet Names]. This can then act as the input for the batch macro or dynamic input.