Look up in two sheets and populate SUM in third sheet - stuck up need help - xls 2007

Calling all experts for help please. Been stuck up for hours now.
I have three sheets in an xls.

Sheet 1
EMP-Weekly Sal
EMP ID || Week || Salary
1 || 1 || 1000
2 || 1 || 1500
3 || 1 || 2000
1 || 2 || 1500
2 || 2 || 1500
3 || 2 || 1500

Sheet 2
EMP-Country-Allocation
EMP ID || CNTRY || ALLOCATION
1 || IND || 0.5
1 || MLY || 0.5
2 || IND || 0.3
2 || SGP || 0.7
3 || IND || 0.4
3 || SGP || 0.5
3 || MLY || 0.1

Sheet 3
Country-SAL-Expenses
COUNTRY || Expenses
IND
SGP
MLY


Now in Sheet 3, expenses column, I need the totals of expenses country wise.
Basically output would be
Sheet 3
Country-SAL-Expenses
COUNTRY || Expenses
IND || 3550
SGP || 3850
MLY || 1600


Similar sample xl attached for reference as well.

Regards
Lily