combining columns in Excel

Hi,

I’d like to open 6 excel files, copy and paste the contents into a 7th file so the data is all in one column.

How could I do that?

Thanks,

Dave