Excel 2007 : Combining numeric data from several spreadsheets into a master spreadsheet

Hello,

This is my problem. I have a master spreadsheet which contains 2 columns:

COLUMN A COLUMN B

Supplier 1 0.00
Supplier 2 0.00
Supplier 3 0.00
etc

Now, I receive several spreadsheets in the same format but containing values in Column B

How do I take the amounts from these spreadsheets, add them up (for each supplier) and paste the total in the master spreadsheet?

I have attached a sample of the master spreadsheet.

Many thanks in advance for any reply, assistance, code.