Need help in Excel 2007

Hello everyone.

Ok, here is my issue. I have a table that is from B14 to U513. In column Q (from row 14 to 513) are numbers from 0 and up.

Here is what I need. For each cell in column Q, if the value is greater then 0, I want to copy the corresponding row onto another sheet. I have 7 sheets I need to do this on and consolidate the copies onto an eighth one. How can I do this?

Please note that although I am pretty good with formulas, I know nothing about programming macros or VB.

Let me know if you need more information. Thank you in advance.

TCB.