How to consolidate 4 excel files into 1 ?

[excelnew]

I have couple of  roster and couple of  zip files. I would like to copy and paste those values into OUTPUT.XLS file.

The original Roster and zip file contains thousands of records. Any suggestion how can I automate this by VBA?

Test files attached.

[excelnew]

Explanation of columns how Output file will be populated
-------------------------------------------------------------------------------

ZIP (Column A):  These values comes from zip2terr A and zip2Terr B files. The zip codes can repeat because one zip code can be assigned to multiple employees (territory).For example 00069 zip code assign to “Kelly Hose” and “ Jina Barbara”

TERR ID (Column B)          :  These values comes from “Zip2Terr-A” file that match zip code of Column A
FIRST NAME (Column C)   :   These values comes from “Roster-A” file that match TERR ID (Column B).
LAST NAME (Column D)   :   These values comes from “Roster-A” file that match TERR ID (Column B).

TERR ID (Column F)          :  These values comes from “Zip2Terr-B” file that match zip code of ZIP (Column A).
FIRST NAME (Column G)   :   These values comes from “Roster-B” file that match TERR ID (Column F).
LAST NAME (Column H)   :   These values comes from “Roster-B” file that match TERR ID (Column F).