Copy data from single workbook into multiple .csv files

Hello,

Can anyone help me create a macro to do the following

Open masterworkbook.xls in a specific directory (e.g my documents)
Copy column A on Sheet1
Copy column A on Sheet2

Open data1.csv located in the same directory as the masterworkbook.xls
Paste column A from Sheet 1 (masterworkbook.xls) into Column F in data1.csv
Paste column A from Sheet 2 (masterworkbook.xls) into Column N in data1.csv

Close data1.csv

The macro then needs to cycle through the remaining columns (1000 in total) in master workbook.xls copying them into column F and N in the respective .csv files (1000 in total)

I.e. the next part would look like

Open masterworkbook.xls
Copy column B on Sheet1 (i.e. next column)
Copy column B on Sheet2 (i.e. next column)

Open data2.csv located in the same directory (i.e. next .csv)
Paste column B from Sheet 1 (masterworkbook.xls) into Column F in data1.csv
Paste column B from Sheet 2 (masterworkbook.xls) into Column N in data1.csv

Could anyone be of assistance, let me know if you need any sample files