appending multiple workbooks with same headers

[bibu]

I literally have 100 workbooks with the same header, is there any way to just put everything together in one .xls file? *except copy/paste
I got the idea of building a macro that copies the content but pasting it is a different matter, I can't get the macro to paste the content on the next blank cell everytime I need to add content.
I'll attach two sheets for exemplification.
TY in advance.