macro to copy and paste between 4 workbooks

erm i need some help i have read some of your post helping others i have a similar problem .
i have 4 files in total.
BN11209011.csv (raw data from log).<only 1 sheet> [foldername LIV]
requires all data.
BN11209011-350MA-25C_OSA.xls (raw data from log2)<only 1 sheet> [foldername OSA]
requires only A,B,F,G
536-00583-350MA-FGOSA.csv (summary of raw data log2)<only 1 sheet> [ foldername OSA]
requires only 1 row
DL-CS5153A(Template).xls ( main file) <total 4 sheets> [ foldername template
i need to compile all the raw data files in to the main file.on different sheets.
there are many other product with the same format.

i am hopeing for it to be a generic type so that i can use the same macro for all the other templates