How do I extract data from one sheet to another, depending on a numerical ranking system?

Hey all, I've got a screenshot below to illustrate what I'm working with. But here's the situation.   On the left-hand window (step three), I have a series with a 1-5 ranking system in the next col...