Batch macro for excel workbooks input

[xariet]

I have a folder with a few hundred excel files. All have 1 tab with same data but with the different tab names. Can you recommend a batch macros that will just pull all the data into a single worksheet? 

[flying008]

Hi, @xariet 

Like this: 

https://community.alteryx.com/t5/Community-Gallery/Batch-Input-Data/ta-p/1116951 

[xariet]

I am not able to download and use this macro  as per security reasons, would you be able to show me a set up in a screenshots please?

[caltang]

Try this: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

Has all the instructions clearly laid out.