Hello everyone! After days of trying to figure this out on my own and searching for help online, I finally found what I needed, but the moderator closed the thread on me so I need to create my own. The below link will take you to this thread.
Copy sheet and rename from a list, ignore duplicates
I need a macro that copies the "Blank Client" tab and creates a new tab for each unique value starting in cell A2 and going down on the "Data Validation" tab. Each newly created tab should be renamed to whatever is in cell A2, cell A3, cell A4......etc on this "Data Validation" tab. If a tab already exists with a value in column A, this Macro needs to skip/ignore it and do nothing. All new sheets should be added after my "Project Tracker" tab (ideally) otherwise at the end. Ideally, this would alphabetize the tabs as well starting after my "Client Tracker" tab so each name in cells A2:A??? on the "Data Validation" tab would be in ABC order.
Hopefully this all makes sense and thank you so much in advance for any support you can provide!!