I have this code that, in an existing open workbook (let's call it "Template"), looks for any tabs that have a name begining with "CC". For each of these tabs, it copies the tab into a new workbook, deletes any extra tabs, then saves the new workbook to my desktop.
Sub Copy_Save_CC()...