How to pull data from a table/cell based on a criteria

[SCPbrito]

So I'm trying to create a worksheet for tracking the workflow in my job. I have one sheet (1st image) that has work-order status( New, in progress, completed, etc) and i want to pull the qty of these work-orders and display them on another worksheet(2nd image) but only when the status meets my criteria. So for example when status is new i want to pull the qty and have it display under new column, when status is in progress i want to pull the qty and have it display under in progress column.

 

[AlphaFrog]

It's not clear which column is the Status column and which column is the qty (there are two quantities).

Do you want the total of all the quantities for a given status? If yes, consider using the SUMIF function e.g...

=SUMIF(Sheet1!A;A, "New", Sheet1!K:K)

 

[SCPbrito]

Thanks for your reply. The status is the column labeled progress and the qty is the column labeled Qty ordered