Combine Several Worksheets within a Workbook

[Erika]

I have a workbook that has 700 worksheets in it, a client would like me to
combine all the worksheets so they are on one. Each worksheet has anywhere
from 6 rows to 125 rows of information.

Is there a quick way via a macro, function or other excel feature, that I
could do this?

 

[Ron de Bruin]

Hi Erika

See this code example
http://www.rondebruin.nl/copy2.htm