Lookup a value based on changes in another cell - Hard one

This is what i have in Sheet1

C D E F
Name Doc ID Unit Amount

Example1 1111111 1
Example2 2222222 2
Example3 3333333 3


In Sheet2 i have this:

B C
Name Amount
Example1 100
Example1 200
Example1 200
Total Example1 500

Example2 100
Example2 300
Example2 300
Total Example2 700

Example3 100
Example3 400
Example3 400
Total Example3 900


In Sheet1, col F: I need to lookup the Total Amount for each Name. The total amount for each Name is located in the 4th row within each Name range in Sheet2, Col. C
The Names in Sheet1, Col. C are not always going to be in the same order OR might not appear at all. There are 20 Names, Example1 through Example20, but not all of them are going to appear all the time because there is a vlookup function(Col. C) that picks up the Names from another spreadsheet based on the Doc ID in Col D.

What formula do i need to have in Sheet1, Col. F to show the total amount for corresponding Names in Sheet1, Col. C considering that names in Col. C are going to change daily.
Any help is much appreciated.
Thanks.
B.