Copy rows from work sheets to combine to one work sheet based on cell value

i need help.
i am wanting to copy rows from multiple works sheets and have one work sheet with only the rows that have a remaining number left in a cell value. i don't want the cells with 0. there are 20 work sheets but many only have one or two rows that i need but that changes baised on the order and what we have done. if any one can help please let me know i have attached a sample workbook.


cheers,
joe

Hi,
I've added a new sheet "Result" to your workbook. Execute Macro - "result" to refresh the data.
Tony

Sorry, forgot the attachment.

thank you, thank you, thank you.

it works great.

this is my first experience with excelforum.com and it couldn't be any better.

cheers,
joe