I've created a workflow which cleans data on one sheet and organises it. Essentially, its summarises 240 lines from one sheet into 12 lines of output.
I've 80 sheets like on one excel file. They are all of the same format.
How do I duplicate this workflow for all the sheets without copy pasting this workflow 80 times. The output - with 80 sheets, I'm looking to get a summary table of 960 lines of output.
I presume this has something to do with recording a macro but couldn't find out how it works.
Would be grateful if someone the most efficient way of doing this. I've attached the workflow and example file for your reference.
