Macros to Create new workbooks and Name them based on a list [Closed]

Report
-
Hello,
I have a template which contains all the templates that needs to separated.
Is there a macro that will separate all these templates and save them as separate workbooks and naming the file as the Tab name ?

EG
Template.xlsx contains:
Tab(Alpha)
Tab(Beta)
Tab(Gamma)

I would like these tabs to be save individually as its own workbook with their respective names in a certain folder
Alpha.xlsx
Beta.xlsx
Gamma.xlsx

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!