Hey everyone,
I have 3 IDENTICAL workbooks (say WB-A,WB-B,WB-C) with 4 sheets in each workbook (say WB-A1,WB-A2,WB-A3,WB-A4 / WB-B1,WB-B2,WB-B3,WB-B4 / WB-C1,WB-C2,WB-C3,WB-C4). These 3 workbooks are basically reports for 3 different projects, which are updated individually on a monthly basis by other departments, and they contain the same type of information.
What I want is to transfer all of the information from all 3 workbooks into one master workbook with the same 4 sheet types. At the same time I want to be able to automatically update the master workbook with the new information added every month from each of the 3 workbooks.
I hope it is clear and waiting for your valuable help.
Marios
I have 3 IDENTICAL workbooks (say WB-A,WB-B,WB-C) with 4 sheets in each workbook (say WB-A1,WB-A2,WB-A3,WB-A4 / WB-B1,WB-B2,WB-B3,WB-B4 / WB-C1,WB-C2,WB-C3,WB-C4). These 3 workbooks are basically reports for 3 different projects, which are updated individually on a monthly basis by other departments, and they contain the same type of information.
What I want is to transfer all of the information from all 3 workbooks into one master workbook with the same 4 sheet types. At the same time I want to be able to automatically update the master workbook with the new information added every month from each of the 3 workbooks.
I hope it is clear and waiting for your valuable help.
Marios