Split Excel Worsheets into new Workbooks based on Criteria

Hi Guys!

I'm trying to figure out how to create a macro code to split up data based on group criteria. I received a file with 40 area tabs and need to split those into 8 separate group files.

I found a code that splits up the workbook into 40 worksheets but I couldn't figure out how to specifiy it to split up to only 8? Any help is greatly appreciated.

Many Thanks!