I have a few csv files in a folder. I would like to copy the data from all
the files in that folder and paste them on one sheet in a workbook using
macros.

Any help will be appreciated.