Directory and Dynamic Input Tool

[calvincarr29]

Can I have an example of Directory / Dynamic Input Tool for this situation please?

Input data from all .xlsx files --> that contains a sheet named "State" --> in this folder --> from this drive 

Thank you for your help. 

[caltang · Accepted solution]

This is the ultimate guide: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

It even has a Batch Macro for you at the bottom.