Different Tables to different sheet in one file, but Block tool is not enough

[Inactive User]

Hello guys, 

Is it possible to save different tables to different sheets in one excel file? I know I could use the Block Tool but I want a efficient way to solve this problem and not to copy every part of this workflow again.... The image show only an example, which I created quickly :D 
Thank you for your help

[binuacs]

@Inactive User When you say table are they different excel files? If yes the a batch macro would be a solution for your use case 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

[Inactive User]

This is not my case.
Maybe I have to explain it more in detail. 
I import a file on which I apply various filters. These parts I want to save in an Excel file. But for each table that I have filtered, I want to save in a sheet.

[Yoshiro_Fujimori · Accepted solution]

@Inactive User ,

If the Sheet name of each table is known,

I would add the sheet name to a new field, and put the tables together with Union Tool.

and then use the sheet name field in Output Data Tool.

Does it work for you?