Joining multiple CSV files together with 1 header

[rpinxt]

Dear experts,
I found ways to join csv files on the internet but somehow I do not get them working for me.
I was thinking it was not that hard, I have a folder on my hardrive which consist of several files.
Now I want the macro to join all the CSV files.
The only hard part was the fact that there were 2 types of csv files. Files that start with AMS it needed to join.
BUT there are also AMSI files which should not be joined with AMS files but with other AMSI files.

I will attach 3 files. Can someone provide me a meaningfull macro which joins the 2 files that start with AMS and then also put only 1 header?
Because the files have the same header.
Other methodes did join the CSV files but also everytime copied the header.
Thanks.

ps: note that I have now 2 files but this could well be 5 or 6 depending how many csv files are in the folder.

[rpinxt]

Maybe good to mention is that I would like the data of the different CSV files in 1 worksheet.
I found this could which works fine, only it add the csv files after my existing tabs as extra tabs and that is not what it should do.
So maybe someone knows how to alter this code so it will paste the data in 1 sheet below eachother? Thanks!.

Please Login or Register  to view this content.

[rpinxt]

Ok I also have found another one which does put everyting below eachother....but....here you have to point out the folder were the files are each time.
I want to be able to put in the path were the csv files are in the vba code!
So if someone know how to alter this one so I don;t have to select the folder myself eachtime the macro runs.

Please Login or Register  to view this content.