Function to Copy all sheets into one sheet

[Des]

Is there a way to copy multiple sheets at once to create
one worksheet, rather than one at a time?

 

[Don Guillett]

You could use a for/each loop

for each ws in worksheets
depends on what and where you want to copy
next