Hello

need help with excel

I have sheet1 and sheet2

Sheet1 has
Person name Bills
John 200
Jack 200
Etc..
..


Sheet2 has
Person name bills date
John 200 given on Jan1st
100 given on Jan15th
50 given on Feb10th


Now I need to add all the bills column of john in sheet2 and add to sheet1

So if I filter by person name : John under sheet1

I need to get o/p as below

Person name Bills
John 200
200 given on Jan1st
100 given on Jan15th
50 given on Feb10th
Total 550

thanks in advance
vj