Is it possible to automate merging data between multiple spreadsheets?

Hi I'm using Excel 2000,

I have this scenario.

I have a master worksheet that must be updated from various sources.


A B C D E F G
ACCT# | CUSTOMER | CUST_TYPE | GCM# | HC# | CIG# | CIS# |

12345 | ABC COMP | SML BUS |002222|88008|C5000 |C5001|
67890 | XYZ COMP | COMM |005555|99009|K7000 |K7001 |
59789 | BIG COMP | CORP | |78889| |K8078|


I have 5 data workbooks from different sources that contain data related to the columns in the master. All with the ACCT# and CUSTOMER as the common identifiers.

example:

Data Workbook 1

A B C
ACCT# | CUSTOMER |GCM# |


Data Workbook 2

A B C
ACCT# | CUSTOMER | HC# |

etc, etc.

These workbooks also have new ACCT#'s that are not on the master.

Currently, I'm cutting and pasting the information. Something which is becoming very tedious, especially as the lines in the workbooks can run into the thousands.

Is there a function, formula or macro to get the five data Workbooks to populate their corresponding columns in the master without duplication whilst at the same time add the new ACCT#'s from these workbooks to the master.

I would appreciate a step by step guide as I am a total newbie to all this.

Thanks.

This might work (I've never used it):
PivotTable>Multiple consolidated ranges.

Ola