Copy a sheet, rename it by value in range then export product to new workbook and rename

Hi Guys,

I have a workbook that, thanks to the enormous help on here, does all kinds of wonderful things.

To finish it off, what I'd like to do is this

Copy the tab called "User to System Matrix" but have all the contents saved as values
Rename the new tab by the value in cell C2 of the "Welcome" tab

Export the new tab into a new workbook and save it with the filename of today ("yyyymmdd - Tabname")
Save the original workbook with the filename of "yyyymmdd - <value in cell C2 of the "Welcome" tab> - MASTER

Sorry, on both the Saves, can it put the filename but not actually save but allow the user to navigate to where they wish to save the files

Thanks guys

Terry