Combining Multiple Workbooks

[LJHS]

Is there an easy way, i.e. a macro ... that can be written to combine
several single page workbooks into one?

For example, if i had 10 workbooks, i'd like to combine them into 1
workbook with 10 worksheets.

Is this possible?

 

[Ron de Bruin]

Hi LJHS

You can try a example on this page
http://www.rondebruin.nl/copy3.htm