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.