How to merge multiple excel file into one without copy and paste?

[badesh]

Hello there,
The answer may be somewhere but could not find.
I want to merge multiple excel file into one. All files has same format, columns. But some has many row and some has few. How to merge into one?

Thanks

[Pepe Le Mokko]

Easy as cake http://www.rondebruin.nl/win/addins/rdbmerge.htm