Sum Formula Help

I'm looking for a formula to do the following on the attached workbook:

New Job Data Template Tab: Under Weekly Data column, I will manually enter in the hours and feet for each Category every week. Example: John Doe, Pipe - Hours = 10 and Feet = 200. Wrap - Hours = 10 and Feet = 300

At the bottom of the sheet lists every name 4 times for Pipe, Wrap, Board, and Firemaster. I am looking for a formula that will match the names, then match the feet or hours, and then match the category name to give me the Total Feet and Hours for each person under each Catagory. I have highlighted example data in yellow.