Move data to cell sheets

I need it to look like this. The other names need their own sheet. After I will be placing other data and it needs to add to the same name or create a new sheet with that name. (i.e with verett the macro would check to see if it exits and then make a new sheet.)