Updating one Excel Table from another.

How to retrieve data to an Excel Table from another identical Excel table on the basis of records of a particular field/ column common to other table from which the data is to be retrieved