Adding multiple files into 1 sheet

[alexmols]

I have multiple excel files in the same format, can I add those files into 1 excel file, placing them below eachother in 1 sheet?

(I've already found some things about macro's, but am not familiar with using macro's unfortunately)

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx