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