I have about 200 individual excel files. each has a single worksheet,
none is over a hundred rows, 8 coloumns.

Is there a simple way to collect all of those spreadsheets, (the
contents of a single directory) into one workbook, importing them into
individual sheets?

Is there a sigle way to just append the data in each of thos worksheets

into a single worksheet as well?

Working with Excell 2003 here.

Thanx