extract multiple data based on criteria

Wow, FDibbins thank you so much, I have been trying to do this all day and you did it in like a half hour. My only problem is that I am running into now is the way I want to organize it is making something mess up on me. I can copy and paste that formula to the right and it works however I only want to go about 6 entries before I want to start another 6 entries on rows below that. See my example. It will not copy correctly when I go back to the original column I start this formula in. Does it have something to do with the "rows" portion of the last part of the formula? I don't understand what that part is doing?

excel 3 example.png


I have a lot of hidden columns too. Could that be affecting it? Should I really try and move those hidden columns to another sheet?