Thread: moving info from one sheet to the next

I have a spreadsheet with revenue numbers by person by month.
Lower on the sheet, i have taken these monthly numbers and keep a running average.
The problem is that I can not copy the averages to an email since they are all formulas.
I would like to use sheet 2 and have the numbers on sheet 1 copied to a duplicate format with the values pasted instead of the formulas. I am currently doing this by hand but I know there has to be an easier (less time consuming)way to move the numbers from one sheet to another and have the Values pasted in the second sheet.

Could anyone point me in the right direction, like what commands to use or a web based tutorial, or whatever help you can?

Many Thanks