how to copy multiple csv files in excel

Hello

I have let say 5 csv files that values are already separated in each column. in each csv files is also data that i dont need. now i want to make some vba code that will copy specific cells from each csv file and paste it in a new excel file. i want to make that vba code will paste it with last used row.

is that possible? thank you

Hello

I need only the results from the csv files. from 5-10 row. ( bla bla file - i send already). it depends on csv file, how many results are inside.

please see the attachment

Thank you

in example file i copy the results from bla bla file and from test1 file that i already send.

Thank you very much

Is perfect