Select the cells
Edit / Copy
Edit / Paste Special / Values

To avoid losing the formulas from your master copy you might do better
to copy the sheets and then replace the formulas in the new copy.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup