need help to combine data

[ANKUSHRS1]

I have many files in specific folder in my pc. I want to combine all those file in to one excel sheet..I need help to create a macro for this.

 

[Luke M]

Code's already been written.

Use an add-in:
http://www.rondebruin.nl/win/addins/rdbmerge.htm

Or copy-paste this code and modify as needed:
http://www.rondebruin.nl/win/s3/win008.htm