combine worksheets

[JBS]

I have exported 1000 pages from pdf into excel. It has created 1000
worksheets in a workbook. How do I combine these into one worksheet?

Thanks

 

[Eduardo]

Hi,
See Ron's macro at

http://www.rondebruin.nl/copy2.htm