Macro For Splitting Worksheets But Excluding Certain Ones

I have a workbook with multiple worksheets, for instance Red, Blue, Green,Orange, etc. I want to split off everything except Red & Blue into separate workbooks.

I want each of the workbooks name to be saved as the value in a specific cell (stays the same for each book), say "A2". I also want to be able to choose the path of where to save these, all worksheets going to the same path user chooses on their comp, but each user may choose differently.

And lastly to keep these actions hidden from the screen when excel copying the worksheets.