Repeat workflow for multiple sheets from a file

[ppatane]

I have a file with Corporate, Finance, Tax, and Other sheets.  I want to run each through the same workflow and output each to its own sheet in the new output file.. ChatGPT says I should create a batch macro and use a Control Parameter to send each sheet name through, but I don't understand how to connect the input file to the control parameter and then connect that to the batch macro.  Help!

[aatalai]

If you have the same schema, you can use the dynamic input tool

[alexnajm]

You can read a list of sheet names in a workflow, then pass that list of sheet names into the control parameter part of your batch macro.

The batch macro will be the workflow you mentioned, with the Control Parameter connected to your Input Data to update the sheet

[binu_acs]

@ppatane Sample workflow attached 

[ppatane]

Hi @binu_acs ,
A couple of things - I see when you ran it, you got three different files, I go 3 of the same.  But I am trying to get all the sheets to export to the same file. Would I need to get a Block Until Done in there somewhere?  I am on point with both you and @aatalai , I just don't know how to open the appropriate sheets from the input file, work on it and then save each sheet to the same output file.  This is what I'm getting using the Dynamic Input Tool

[binu_acs]

@ppatane , you want the output in a different file with the same sheets with data? is it like creating a new copy of the same file?

[binu_acs · Accepted solution]

@ppatane I  updated the workflow to create a new file and save the Excel sheets as it is

[ppatane]

@binu_acs There will be intermediate steps from input to output