Please help. I have a workbook with multiple tabs. Each tab has hundreds of
formulas that refer to other spreadsheets and/or databases.

Each month, I need to be able to

A) Copy / PasteSpecial Values for all contents of each tab, so that no
formulas exist, just static values

and

B) Save the workbook as a new workbook with the name located in Cell A1,
Sheet1

My guess is that it would be three macros.
Macro 1 would do the Paste/Values for each tab
Macro 2 would do the Save As
Macro 3 would run Macro1 then Macro2

Thanks in advance for any help. It is much appreciated.

Scott