OK so here is my problem that I hope you can help with. At work we have what is called a “daily task List (DTL)” for the employees to do throughout there shift with each DTL being different on each day of the week.
What I am trying to do is load is input everything into a timing worksheet (the image in yellow) and have is auto-populate correctly into each of the seven different worksheet. Let me explain in more detail below:

Ryan, Moe and Nick, who are opening need to be inserted into the yellow highlighted area. AS you can see though there are 5 spots so I need the inserting to go back to the beginning and start at the top of the openers.
I then need the orange to be filled with both Openers and Mids while the green needs to be filled with Mids and Closers.
I can send the excel spreadsheet if you need it. Also if you need more clarification please ask
Thanks
David

There are 2 worksheets in this attachment.

The first sheet, you have to select a name from column C. The drop-down is dependent on the number of people per shift.

YELLOW = OPENING STAFFS
ORANGE = OPENING AND MID STAFFS
GREEN = CLOSING STAFFS

The second sheet does it automatically. You just need to select an employee E6 and the rest will populate.

This is what I was looking for, with a slight tweak though. Is there any way to have the cells in worksheet DTL 2 J6-20 auto populate into the E6-20 cells? When I change the info in the J6-20 cells nothing happens on the E 6-20 cells with the exception on changing of the names.

Also can you tell me how to edit the code you used? I have to place this into a pre-existing template. It needs to look exactly like the first attached image.

Thanks for all your hard work, very much appreciated

Once you changed the names on column J, just change the name on E6 and the rest will follow.

The formula is quite hard to explain though... You can attach your template and I'll do it for you. ^_^

OK, I have added the template. As you can tell, each day of the week are in each worksheet as well as a worksheet to do the timing inputs.

Thanks for all the help

Here's your template.

I have included some instructions on how to use the template.