How to copy data from one excel table to other

I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined.

Now, I want to populate this table from another excel table which is a subset of the master table ( only certain columns and row heads common with the master table). In other words, I need to write a micro, which can do a two way ( vertical / horizontal ) lookup in table 2, and then populate the data at an appropriate cell in the master table.

Any assistance is greatly appreciated.