Output to multiple sheets using Excel template based on a field value

[ICC2022]

Hi there,

I would like to generate 10 output sheets using a same excel template for 10 individuals. For now I have 3 master sheet where it contains all individual's name and the raw data to be imported to Range 1 to 3 respectively on the output page (see pic attached for my output template).

I wonder if there is a way to generate the outputs for 10 individuals all at once, with Alteryx filtering what should go to Range 1 - 3 by employee name. In other words, if the Name cell = Employee 1, it will pick up the information in raw data sheet with Employee 1's name there and roll it to Range 1 - 3 on the output page. If Name = Employee 2, they will find the data for Employee 2.

If anyone can share some thoughts on this it would be super helpful. Thanks in advance!

[Qiu]

@ICC2022 
I had a reply for a similar question here.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Changing-one-sheet-of-a-template-outpu...

[ICC2022]

wow seems quite advanced but will take a look, thanks for the quick reply! Will mark it as solution if works for mine.