Why not saye the file using a temporary name, then delete the sheets you don't want
Then save the Tempoary file under the new names, Team1, Team2, Team3 and then the original name
Delete the Temporary File
Open the original file

The macro should be housed in your Personal Workbook.