Hi, I have a list of names from A1:A120 and I would like to create a macro that will add a new worksheet for each name in the list which would then give me 120 sheets.

If somebody could please help.

Thanks in advance.