Hi Heather:

Have you considered an Excel add-in like this one.
http://www.digdb.com/excel_add_ins/c..._sheets_files/
?
If you type merge excel files or combine excel file or append excel
files in Google you will get many more tools like this one.

Best regards,

Christophe