VBA - Split multiple tabs into a separate Excel Sheet

[SLS2433]

Hello,
I have an Excel sheet with multiple tabs. One tab has lookups into the other tabs, so what is the VBA code I'd use in order to select multiple tabs and save these groups of tabs into separate files? I've read how to split rows, columns and one sheet into separate files, but cannot find out how to group tabs together and save them into separate files. Thank you!

 

[hajiali]

Try adding below to your code

    Sheets(Array("Sheet12", "Sheet14", "Sheet16")).Move ' names of your Sheets