Copy specific sheets to a new workbook

[Martin sherk]

so i have a workbook with sheets that have data based on customer codes , for Ex: company code USA1 has 3 sheets: (USA1, USA1 distributors and USA1 PVT) Like elaborated in the pic below.

what i need is:
A VBA code to copy all data of these 3 sheets that starts with USA1 and paste it in a new workbook and name it USA1 Payments then save and close that workbook.

please note that i have 6 other company codes that goes like this USA2, USA3, USA4 and so on and each company code has 3 sheets as well.

I Appreciate your time reading this and thanks in advance.

 

[Martin sherk]

@HaHoBe Brilliant, thanks for showing me new ways to do this and for the time taken answering all my questions.
I wish you a wonderful day sir.

 

[HaHoBe]

Hi Martin,

glad that I could help on this one and thanks for the feedback.

Holger