How to make a working stock order sheet for a small business?

Hi,
I'm at a total loss and am very new to using Excel.
I run a small business designed around printing and i use Excel for stock maintenance etc.

The spreadsheets i have created tell me on each page what stock requires ordering and how much it costs me etc, however with so much stock on each page it is easily missed.

i'm trying to find a way to get those lines that say they need ordering, to appear on a separate sheet so i can print the form off and not miss crucial lines.
The information i would require would be :

garment or item description.
cost value to me.
qty to order.
supplier Code.
supplier.

I currently sell over 600 lines, so i don't really want to see all the things that don't require ordering.
Is this possible? Any help is useful.

Luke