If you have Access, you could import all the tables to Access, run a Union All Query and then export the results back to Excel. It would take depending on the size of the tables only a few minutes.

Alan