Need a macro or tool that can open 50-60 files

[Galena1]

Need a tool or macro that can take 50-60 Excel files, that come in weekly, as attachments to individual Outlook emails, open each file, and then merge (append) them into a single Excel or CSV file. Probably only 3,000 records total. All files have the same headers and formats.

I suppose I could download the files, from the Outlook emails, and save them to a unique folder on my C:, justto make things a little easier.

Any ideas?
Thanks!