VBA Save as new workbook & remove SOME formulas across sheets?

[Melimob]

Hi there

I'm on the last bit (finally) with this project.

I now need to:

Save as new workbook
Name should be: [Country]_Move_Template_[todaysdate]
Country would equal a named reference on Worksheets("Instructions").Range("Table13[Country]").Value

the user would need to choose the folder and file path of where they want to save it to

but here's the tricky bit..

I need to save without formulas (copy paste special value?) across all sheets except to keep formulas in:
Sheet: COD Mapping
Ranges D3:BA4 & D20:BA21

Sheet: CC Reconfiguration Data
Ranges G3:variable down length but this is a table so should copy down in column right?

and I don't want to keep the 'Instructions' sheet tab?

I also have some datalists in some sheets, would these copy over with the named ranges (lkup sheet containing the drop down lists will be moved over).

Then I want it to have a message question to say: Do you want to notify the team? If yes, it will open up an email with addresses and a standard message but they will have to press send

Is this possible or should I have the last piece in my main macro?

many thanks for any advice!

Melimob