I have 225 Excel files, each with one worksheet, all with exactly the same
colums and headings. Is there a way to combine all 225 worksheets into one
long single worksheet? I need this to export to an Access table.

I also have a workbook with 35 worksheets that should be combined into one
worksheet, for the same reason.

thanks,
Mike