This should be possible with the out of the box excel exporter. You'd need to set 12 associations and create individual sheets using each.
Hi Mike,
I think the two things that you are trying to do is be able to dynamically change the names of the excel tabs and control how many sheets are exported? And your data is separated by separate entities that are associated to the report parent?
Here is a microflow where I have a template with 3 tabs setup, and if the data doesnt exist for one of the tabs, I remove the sheet from the template before exporting. Also if the data does exist, I change the excel sheet tab name.
https://modelshare.mendix.com/models/7b748b51-1b81-48dc-9da2-911d9bff6560/createexcel-report
The domain model that I used was this. Hopefully your structure is similar.
Also here is the test project where I did the example.
https://drive.google.com/file/d/1yVSBv7wNzTQrFqDDQJoOewZVuaqkkl9p/view?usp=sharing