Filtered data formula question

Hello,

I'm not sure if this question would be better suited in the programming thread or not, but I was hoping there would be a formula to do what I need rather than vba coding.

I'm attaching a sample workbook as an small example:

In this sample workbook, I have two sheets/tabs. Ideally I want to filter by an individual name on the "Yearly statistics" tab, which will then allow me to see that single person's individual data. Once this filtering process takes place I would like (via a formula if possible, but vba would suffice if no other way) to have the 1st quarter data for the filtered individual to post in the appropriate summary cells, etc. The 2nd quarter results in that appropriate designated field and so on...

So if one were to filter "Jane Doe" on the yearly statistic tab; the number "19" would show up in the traffic enforcement cell on the 1st quarter summary cell G2 and "11" would show up in the self initiated arrest cell G3, etc...If data in the 2nd quarter columns, it would then show in the 2nd quarter form below the 1st quarter, etc. I hope this makes sense. Any assistance would be greatly appreciated!