I don't think you're going to find a way to do that all in one shot.
It sounds like if you have three sheets in your workbook, you want to select  all
three sheets, copy  them to the clipboard, then paste  back the "values".
the problem is that Excel expects a location to paste them.

The best you can do is set up a loop that cycles through all of the sheets,
selects the data, does the pastespecial, then moves to the next sheet.

I don't think you're going to find what you're looking for, because copy/paste
isn't an option with worksheets, but with the CONTENT of worksheets.

If you want help with the loop, let me know.