copy a single column from mutiple workbooks into a single workbook

Hello,

I am after a macro that works through a sequential list of workbooks and copies column G from each workbook and posts it into a master workbook in a sequential order, i.e. column G (workbook 1) to Column B (master workbook), column G (workbook 2) to Column C (master workbook) and so on.

Unfortunately I am family new to VBA so any help you could provide me writing and using said macro would be really appreciated.

Here is some additional information that may be of use to you.

The workbooks containing column G are currently called r0001_scen_dly.csv, r0002_scen_dly.csv, r0003_scen_dly.csv up to 1001. They are all currently located within the same directory: C:\Documents and Settings\S151197\Desktop\Cambridge NIAB (Low)\WG daily time series (all variables).

Regards

I am using Excel 2007, the information on my profile wasn't correctly updated.

Thank you Dom

You have just spared me countless hours, the script works fine

Regards