code to copy first rows and sheet titles from separate csv files into summary sheet

Dear experts,

I have a number of csv files, in each of these only the first row is filled with relevant content in cells A1:I1. I want to batch import the content of column A-I in row 1 from each of these files into one summary sheet so that the summary sheet has as many rows as there are files imported. In addition to that I would like the sheet names of the imported files to be added in the first column of the summary sheet.

Do the files to import need to all be in the same folder or can they be in subfolders, too?

I have experimented with bits of code I found on the net but ended up getting errors. I should probably add that I don't have any previous experience with VB and macros, just with standard excel.

Your help would be much appreciated, thank you!

Hi !

It's easier for a VBA beginner to have files within an unique folder !
For subfolders, use Dir VBA function in a recursive way …

You can start your code just by activating Macro recorder and operating manually.

Hi.. Can't post the code as the Sucurri firewall thingy stops it for whatever reason

See attached workbook...

Hi apo,

The file works great, thank you very much! Just one more thing, is there any way how the file names
of the original csv files (the ones from which the rows are imported)can be somehow written into
one of the columns of each row as part of the import?
The csv files contain results from simulations, but the file name contains a description of the
case that has been simulated, so in the summary file it would be good to see both...

thanks so much and regards

Oops.. I missed that part.. see attached..

Thank you so much! That sheet does exactly what I need now. Much appreciated, that really helps!