Union data from all files in a directory

[L_Gordon]

How to union the data from multiple files in the same directory with the same schema.  There is only 1 worksheet in each file but the names are different,.

[MatthewO]

@L_Gordon you can accomplish this with the Dynamic Input tool.

[binu_acs]

@L_Gordon One way of doing this with the Dynamic Input tool

[grazitti_sapna]

@L_Gordon , Please find the below workflow, This workflow will be useful in all cases. Multiple workbooks with single or multiple sheets having same or different schema. You can use it for any case.

[bradleyareese]

Thanks!  This worked!

[jackallen]

This was a lifesaver, thank you