Automatically copying columns from one work book to another.

Please I need assistance with a problem I've struggled with for quite awhile. If I could write code I'm sure it would be quiete easy.
My issue is:
I receive csv files from my vendors with product data (Sku, price, quantity, description, etc) in each column. ( lets say workbook 1) I have several websites that this product data needs to be listed on, each with their own csv template. (Lets say workbook 2)
I please need how to automatically transfer each column from workbook 1 to its matching column in workbook 2).
If someone could please give me the generic formula where I can input the various cells/columns this would be so helpful.
The automation would happen when ever workbook 1 is received. The .csv files are manipulated in an excel format.
Thank you all so much I appreciate this very very much.
Bonnie