Help needed opening workbooks then copy and pasting!!

Hi All,

Strange request and I haven't a clue where to start!!

I need to create a macro that will look at a list of .CSV files within a folder:

Open each .CSV (one by one)
copy all the data from column A
Paste into column A of the result sheet
close the .CSV
------------
open the next .CSV
copy the data from column A
Paste into column B of the result sheet
close the .CSV
------------
open the next .CSV
copy the data from column A
Paste into column C of the result sheet
close the .CSV
------------
and so on, and so on etc.

The 'result' workbook would be one worksheet containing each of the column A contents from the opened .CSV files.

Probably not too tough for you genius minds out there, but I'd love to understand how the code ticks!

Can anyone help please?

Thanks for looking!

Guy