Directory Tool to Input Multiple Files - Need to Combine Tabs within these files

[kmcgraw2]

I'm using a directory tool to input multiple files within a folder. Some as xlsx and some are xlsb. There are three tabs within each of these files that I need to combine. However, they are all named differently (based on the month).

For example, 2019 Q1 File includes these tabs: A3a. JE 314 Feb, A3b. JE 314 Mar, A3c. JE 361. 2019 Q4 file includes these tabs: A1a Oct JEs, A1b Nov JEs and A1c Dec JEs. I'm looking for the most efficient way to combine all of these tabs despite the different names.

[Warcry]

Attached is a workflow that would fit your questions dynamically.

[caltang · Accepted solution]

I would recommend a batch macro approach here: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

You can filter the .xlsb out and .xlsx out, then have separate macros (for .xlsb and .xlsx) run them and Union the data as well. 

[kmcgraw2]

I received an error that says that macro can't be found

[Warcry]

Did you export everything from the zipped workflow