if you want
to select all the worksheets and paste them back to THEMSELVES to
get rid of all the formulas, you can do that with:
Worksheets.Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Select
Application.CutCopyMode = False
but, if you need to copy all the sheets to ANOTHER workbook, then
you're right, because you can't paste all the sheets at the same
time into a new location. For that, a loop would be needed, as you
said so far as I know.