Select From Drop Down and Pull Data From Different Sheet

Hi

I've started a report that generates unit/$ orders by an account by style & color.

Currently I have it set-up where I list all the styles and based on the Account & Division drop down selection I'd like the data to populate.
So I'm wondering how I can set it up where when you select the Account and Division it only pulls only the styles ordered & related unit / $ amounts by month in the cells below. Thus eliminating all the empty cells and creating a shorter and more concise list.

Below is a snap shot of the report. The arrow shows where the data would populate and it would be all the data highlighted in yellow.

Ord Stat.JPG

what I usually do is add a helping column (Maybe Z) to your list of orders - that has a formula that looks back to the Choices I1 I3 on your summary sheet. If(And(X2=Summary!I1,Y2=Summary!I3),Countifs($X$2:$X2,Summary!I1,$Y$2:$Y2,Summary!I3),"")
That will basically look at your choice and start numbering all the orders.
Then on the Summary sheet you can use Index Match Index(Orders!A1:Z1000,Match(Row()-1,Orders!Z1:Z1000,0),Column())

Something like that

Thank you...I try it out.

I'll have to look through this one as it's a little intense for my excel level lol