I need to write some kind of macro or other kind of script to do the following;

I have a folder with around 30 excel files, all in the same format with 2
columns.

I want to be able to run something to add them all together into one excel
spreadsheet, so that one is pasted after the other, so the first file is put
in their, then the next file is pasted in the first empty cell after that and
so on.

Is this possible?