building several workbooks from several workbooks
 

I have 3 workbooks A,B,and C, I also have 6 workbooks 1-6 which
contain 3 sheets each. what I want to do is have workbooks 1-6's
sheet1 go to workbook A sheets 1-6, workbooks 1-6's sheets2 go to
workbook B sheets 1-6 and workbooks 1-6's sheets3 go to workbook C
sheets 1-6 without having to open workbooks A,B or C. Is this possible?