which formula to use?

I need the data from the "DATA" tab to auto populate into the "TEMPLATE" tab.

The data entered on tab "DATA" will always be different. So I can not simply link the two.

My template will be broken down into groups "RN, LPN, HCA". I need the names of each employee from the "DATA" tab to populate into each corresponding group.

I have attached a basic spreadsheet as an example.

TEST.xlsx9.46 KB