Extrapolating spreadsheet data

Ok, I'm not real sure how to put into words what i'd like my spreadsheets to do, so I'll simply show you a sample.

I'd like to filter data from the first table and create another table similar to the smaller one. And, i'd like for it to automatically update as I add information to the larger sheet.

What formulas would I need in cells F34, G34, H34 to pull and add the data together like i have it shown?

Any help is great.

Thanks,