Running multiple tabs thru the same workflow sequentially

[m_shur]

Have a workflow that flattens the excel tabs (from multiple files in one directory) based on cell locations in the tab amongst other criteria.  All tabs follow the same format.  I am trying to funnel in each tab at a time, run it thru the same workflow and union/append the end results of each tab.  I've tried batch macro for it but can't seem to put a set-up together that does the above.  Every solution I've come up with first appends all the tabs together BEFORE running it thru the workflow, so all I get is result for just the first tab and then workflow stop with it being location dependent.  

 I've attached sample input tabs (two tabls), and the eventual appended output that my workflow produces (currently feeding in each tab manually in the workflow)  and a snapshot of workflow that produces the output.

I am new to Alteryx...is there something obvious I am missing? thank you in advance for any tips. 

[Raj]

@m_shur 
Add the macro created here will try to alter it as per requirement.

[oneillp111 · Accepted solution]

This might get you started, let me know if the package is bad, I have never created one.

Basically it takes an input and finds all the sheet names and in this case removes the output sheet

Then passes that through a second macro to flatten and group the data

[m_shur]

This is really helpful, thank you. For the second macro, could you share the MacroDummy.xlsx that's feeding into second macro?  I am trying to modify the second macro slightly and breaking something in process.

[oneillp111]

Just added, it was just a browse export of the input to the macro as a template.  

[m_shur]

The second macro doesn't work when I input an actual file and add a Record ID for the tabs for that file (RecordID doesn't show up as a field for the Batch macro number 17 and gives 'must be mapped to a field' error) but should be able to play around and see If I can fix it.  Thank you for your help.  

[oneillp111]

can you send me what you are actually submitting?