Finding a matching value & returning another value

[JJanssen]

I am a novice at this, but I need to search through a set of workbook pages, compare an activity code from one column, then return the number of hours next to it to another location. Ideally I'd like to summarize all of it on a separate page, but I'll settle for each page.

See the attached for my start at setting it up. I've placed a column under each numbered category and was trying to compare the Activity Code from D to the numbers in the column and returning the hours if there is a match.

If there's an easier way, please share. Thanks!