@HeliaS, thank you so much for your feedback - it's very helpful!
As to your question - "How can I import multiple workbooks and multiple sheets dynamically?", I have a small example built, but it is not as simple as the processes we discussed in today's training. My recommendation is to start with the ultimate input data flow chart. Ultimately, you'll be looking at building out a batch process. Attached is my batch macro that worked for one of my directories that a) had differently named files, b) differently named sheets, and c) identical schemas. If your schemas are not aligned, there would be some additional effort beyond what I have posted here.
To demo my workflow:
1) Download the two .xlsx files and put them in the same directory - anywhere on your machine
2) Unzip the workflow
3) Point the directory tool at the location you saved your two .xslx files
4) Run it.
The main workflow contains a batch macro, which in turn, contains a batch macro. The workflow is simply sending the directory .xlsx files into the batch. Now if we jump into the first batch macro, you can see that I am simply updating the input data tool to give me a list of sheets for each .xlsx. I could pipe these into the dynamic input, but the template has to be specified for each file. So I take the first sheet, call it the template and pipe it into the "sub-bat" which dynamically changes the template for each sheet. If you want more details, check out this post.