Spreadsheet builder in excel of google sheets

[aproberts1980]

I want to streamline a task for work colleagues I have a master excel sheet with 50 sheets in. Not all sheets are required each time a new copy of the spreadsheet is created. Is there a way to generate a menu within a front page on the spreadsheet where you could de-select the sheets that would not be required in the new copy and then using a macro remove the unwanted sheets from the newly generated spreadsheet. Even better would be the ability to carry out this same process in google sheets and have a script that would delete the sheets and generate a new copy of the google sheet within the a new folder destination.