自动更新VBA代码中的文本

I have a spreadsheet called Team-A, which contains VBA modules. I also have a macro in this sheet that is run to create a duplicate of the same spreadsheet, but data imported for another team. It then saves it as , which conta