The easiest thing to do is to add an output data tool to the stream you want as the first tab and configure it as shown here. Then copy the tool and paste it to every one of your other 8 outputs and connect the data stream to it. For every one you have to change the sheet name. which is the bit highlighted in blue below. Also make sure you change the Output option the Overwrite sheet.
There is a chance that you'll get some errors if one or more output data tool tries to write to the file at the same time. In that case you have to use block until done tools to sequence them
You can create a single output excel file and write to different tabs e.g. sheet1, sheet2,etc.
Please do not forget to use the Block until done tool for all outputs after the first tab( e.g. sheet1) . This way you can avoid getting error from Alteryx saying" The excel file is currently being used by another process..."
@RAJAYKUMAR001, consider using the Reporting tools to create your tables (which can include custom formatting) and use the Layout tool, configured to "vertical with section breaks", to create one Excel output file with 9 tabs using the Render tool.
Here's a video showing how to use the Layout to arrange these reporting snippets: