I have a list of data below. I need to create a unique workbook for every
unique name, while creating the worksheets in column A assigned to that
workbook in column B.
For example, the data below says that I will have one workbook named Alan
Groby. Inside of that workbook there will be two worksheets; one named
Import/Export Compliance and the other Video Conferencing. I have verified
that all column A data is correct symbols and length for worksheet names.
Then I am looking now but I will need to copy a source worksheet data into
each worksheet in every workbook. Basically this will a template for each
worksheet; it just has some colors and stuff that is it. But my main goal is
to get workbook and worksheets created ASAP. Thank you

Column A Column B
Import/Export Compliance Alan Grobey
Video Conferencing Alan Grobey
Disaster Recovery Proposal Anne Elledge
Upholstery Move Anthony Glathar
Trade Show Booth Bill Staser
Dental Furniture Special Bill Stewart
Cuspidor Replacement Prgm Bruno Zadnik
Raw material callout on dwgs Bruno Zadnik