We just merged 239 excel files in seconds. All the data was vertically appended, line by line into one master file. There is a fairly inexpensive program that will merge excel documents into one master file. Data is vertically appended. The program is called Excel File Merger.
Not only will it merge excel files, it can also merge pdf files, even merge doc, csv, and text files. All these formats in one app.