I have a number of CSV files of data that I want to Union together into a single table in MS Excel. All the CSV files have the same names and number of columns.

In a relational database like Access or SQL I could use a Union Query, but this has to be in Excel. How can I quickly merge all of these files into one in Excel?