Create new workbook from Other selected XL file sheets from userform using checkbox

Dear Experts,

Good day, I need one help. I Trust this Forum definitely will solve this thread.


1. I need to create new workbook from userform with check box copy from multiple sheets from other XL file, the files includes pivot tables, graphs and values.

2. There are 4 teams , if I select Team 1 from combo box it should visible only Sheet1, Sheet2 & Sheet 3 like Team 2 and Team 3.

3. Finally if i select specific check boxes only and Click Generate report from command button that sheets should copy the same sheets with name and create a new XL file and save with Selected team name.


PFA sample copy of XL file. Kindly do the needful.


Thanks

Kumarpk