I used to use a macro I found online to duplicate a worksheet based on a list of names. It is very easy to do, using a macro, but I found an even easier way! I use an add-in for Excel called Kutools and it makes using Excel even easier!
Check out the video below to see how I do it.