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?