I am trying to figure out how to do this macro i am not familiar with this type of programming

i have some xls files they have fields inside and i want to copy from each file same field and put in one xls file in row they all are in sheet1

example

File 1

Description Name ID
Intel David 245

---------------------------------------
File 2

Description Name ID
Intel 2 David 2 246
---------------------------------------
File 3

Description Name ID
Intel 3 David 3 2467
---------------------------------------
there are a 9000 files like this all what i am looking to do in one file is >

Description Name ID
Intel David 245
Intel 2 David 2 246
Intel 3 David 3 2467

etc...


Thanks if some one can help me with this