Dynamic Addition of Column, Dependent on Names

I have a spreadsheet that is sent weekly listing names and various amounts that are owed by those names. The spreadsheet can vary in names and length, but the column will be the same for the amounts and names. I need to take all the names, assign the department they work in, then take the totals for each department by adding each employee amount within that department.

What I've been doing:
I can copy just those amounts into a different spreadsheet, then using a separate spreadsheet, manually enter their department #. Then I'll add based on the departments. The problem is that this can get pretty time consuming and it happens every week. Sometimes the list of names is short (around the 50 mark) but other times can creep up into the 100s-200s mark.

My Question:
Is there an easy way to set up a spread sheet that can somehow go through each employee, compare it to a separate spreadsheet that contains the employee and department, then assign the department to that employee. Then finally, automatically add each department?

I don't know hardly anything about VBA, but maybe that might be the route I have to go?

Here is a VERY small example workbook:
Sheet 1 Column A contains the names, Column B contains the amount. I need to populate Column C with the department, then add the department totals.
Sheet 2 Column A contains a list of names, Column B contains their department.

liteExample.xlsx

Any advice and help would be very much appreciated.

Ah yes! Thank you JieJenn. That's what I was thinking I was going to have to do was a VLookUp type deal. Not sure of what IfError does, I'll have to look that up. For the Pivot Table, does that dynamically populate? I'll mess with it and see what happens. Never really messed much/understood Pivot Tables.

I guess now is there a more efficient way of having this calculated? Rather than having to copy in a formula into a new spreadsheet each time as I copy in the data from the speadsheets I get every week...