Is there a way to make an excel sheet covered in formulas
copy itself and create a new spreadsheet with values
instead of formulas to be emailed as just one sheet of
information?

I don't know where to start, I am quite new to vba so be
gentle!

Lynda