Copy row if value is greater than 0 to new sheet

[mrsshak]

Good Morning.
I am a bar manager and am looking to make my ordering easier. My predecessor made a workbook that has sheets for each month. I only have enough experience with excel to add what was received (IN) and what was used (OUT) each week, there are formulas to change my "on hand" and "to order" counts. I would like, when the "To Order" column is greater than 0, to have those rows copied to a new sheet and sorted by "where". I only need the name of the liquor, from and to order columns on the new sheet unless the entire row copied is better.
TIA, if a macro is more appropriate than a formula, let me know and I'll post this there.

[daffodil11]

I imagine this would be simpler using a macro, but it could be done using an autopopulating Order worksheet for each month using rank.

I'm not sure I understand the "where" you want to sort by. Does this imply matching the liquor with the vendor?