Pulling info from a master over to other worksheets.

I have 188 stores, with 18 different possibilities. ie: store # 1, Western, Fabric, L&G Zone 1, L&G Zone 1A.

If I have the master with all of the columns checked (coded) for each store, how can I pull the stores that meet certain cirteria over to a new worksheet?

What I know about Excel is very little. I have tried reading the book and looking in the forum for help but can't come up with a solution.

I have worked mostly with VLOOKUP, HLOOKUP, and IF formulas. Beyond that I'm lost.