Import and merge all csv files in a folder to excel worksheet delimited only by a comma

Hi and thanks for your help. I need a macro that imports all csv files in a folder into a single excel worksheet delimited only by a comma. The first row of the cvs files is a header, so only one would be needed. All help would be appreciated.

Any help would be greatly appreciated.