Macro Possible?

[Dolemitefunk]

Hello, I was wondering if it was possible to write a macro that can automate the following scenario:

Lets say I have Workbook 1, that has values in rows 3 to 15 in columns B through D.

I would like to write a macro that Copies Column B for Workbook 1 rows 3 through 15 and links them into Workbook 2 Column F rows 5 through 17.
And
Copies column C from Workbook 1 rows 3 through 15 and links them into Workbook 3 Column F rows 5 through 17
And
Copies Column D rows 3 through 15 from Workbook 1 rows 3 through 15 and links them into Workbook 4 Column F rows 5 through 17
... and so on.

I would like to know if this is possible, and if so possibly a bit of direction as to how to get started?

Thank you

 

[texasalynn]

Start with using the macro recorder. Then after that you can change up the macro to make it more generic.