Is it possible to have a summary worksheet in an Excel spreadsheet and then
copy this worksheet on its own to another document but with the numerical
values only?

I have a worksheet which is a summary of various other Excel documents
linked together. I wish to email this summary page with the numerical values
only. I don't particularly want the file paths showing in the document I
email - I just wish the numerical values - not the formulas which produce
these values. Is this possible? Without going through complicated
procedures.