Creating a batch macro that generates individual Excel tabs for each breakdown

[latte]

Hello,

This a fake sample of survey data on group plans. The plan has a unique ID and basic plan information such as industry, assets, number of participants, contributions. We create groups based on their asset and participant figures.

Using the asset and participant groups, as the breakdown i want a macro that will generate a new Excel for each breakdown and for each metric (assets, number of participants, contributions). This is only a subset of the columns but ideally, the final output will contain all the various breakdowns in one tab.

I currently run two of the nearly identical workflows to generate an excel with each workflow's output as separate excel tabs. Is there a way to just have a batch macro so it runs through every breakdown (participant group, asset group)?

I believe I'm missing some tools in the workflow but don't know where to begin. I would like a workflow with as few edits as possible so someone with little Alteryx experience can run it.

Any assistance from the community would be great!

version 2022.1 x64