Writing several output files to existing sheet

Question

Hello, I have the following dataset. I want to create several output excels. 1) The Department ID should seperate Excel files and 2) Team ID should seperate sheets in each of those files. I have attached my current workflow.

I have managed to create this, however I need to output of each file and sheet be written to an existing template to perform analysis on those sheets. Anyone know what I'm doing wrong here? I can't seem to get the Excel files and sheets to be written to an existing template. Thanks a lot in advance!

test.yxmd

BS_THE_ANALYST · Answer

@AlteryxPrime666 
Check the Output Data tool's formatting i.e:

Yours is set to Overwrite Sheet or Range. Presumably, this is overwriting those cells in that template. Have you checked if that's affecting your template sheet somehow?

Couple of questions:
1) You could do the Analysis part in Alteryx and build that logic in here
2) Are the Analysis sheets (in excel) pointing to the newly output sheets from Alteryx? 
i.e:

binu_acs · Answer

@AlteryxPrime666 the blob tools would be an option for your use case.

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280