Lookup Across Multiple Sheets

[snake10]

Hello,

I am trying to wrap my head around a question and could use some assistance.
I am working with the following: (I have attached the sheets as examples.)

1 workbook sheet that is a reconciliation of monthly spending, by vendor that details each transaction. In that sheet there is a 'Category ID' which identifies a data type of wireless, Local, Long Distance, Data, Internet, or other and the office location.
I need to lookup the value of that 'Category ID' from a table of ID codes (separate workbook).
No problem with that....

What I need to do is then return the values 'Amount' and 'Vendor Name' to their appropriate tab sheet (in workbook TAG_Area_Sheet).
The sum of those totals needs to go to the Master Sheet tab.

Confusing I am sure, I know I am! Currently, they do this lookup by hand every month.

Any help would be greatly appreciated.

Thanks,

Mike