Macro to create new sheets in a workbook based on a name list

[Hart]

I have a list of names on a sheet in a workbook. Using the list, I would like to create a new sheet for each name in the list and name the new sheet based on the name. The new sheets would be added "BEFORE" the currently selected sheet. Thanks.

 

[smozgur]

Works great, thanks again

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.