How do I consolidate many sheets in same file to 1?

[IEW]

I have a workbook that contains 465 sheets. Each sheet has about 50 items. I
would like to append all to 1 worksheet to export.

 

[Ron de Bruin]

Hi IEW

See this page
http://www.rondebruin.nl/copy2.htm