Generate an excel with sheet for each category data

I have nine different category types for any given main process. The requirement is to create an Excel spreadsheet with each category appearing in its own sheet.

What should be the best approach to achieving this?

Currently, I am creating an excel for the first category and then using that same excel for the subsequent categories in Export DSE to Excel smart service to add a new sheet via sheet number. But this process is sequential and not efficient enough if each category has a huge amount of data.

I attempted to generate Excel for each category and use the merge excel document smart service, but it did not work as I thought it would. Basically, it is dumping all category data onto a single sheet.