Dear all,

I'm new to this forum and would like to say Thanks in advance for the help provided!

I've got a little problem which I haven't been able to solve. I need to extract information in certain cells from multiple CSV files into Excel.

Here is a sample CSV files:

"Item",1,2,3,4,"Tot/Avg"
"Material","","","","","N/A"
"HV",39,39,36,31,"36.3"
"HK",111.39603960396,111.39603960396,111.366336633663,111.316831683168,"NA"
"HRB",54.3960396039604,54.3960396039604,54.3663366336634,54.3168316831683,54.4
"HRC",-1,-1,-1,-1,0
"HK","111","111","111","111",111
"Include","Yes","Yes","Yes","Yes",4
"ImageX",640,640,640,640,0
"ImageY",480,480,480,480,0

All I need is line 3 and cell contents 2 to 5 (i.e. cells B3:E3 if openend in Excel). Plus, I also need to extract the file name and cut & paste all this into a new worksheet in a format like this:
A1 - filename
B1:E1 - cell contents as highlighted above

All in all there are some 300 files with the same format (file names are 1.csv to 300.csv) and I'd like to have them in Excel in one and the same worksheet (A1:E1 info from 1.csv; A2:E2 info from 2.csv and so on).

Any suggestions would be much appreciated!

Thanks
Frank