Copying Rows to New Sheet Based on Column Value

[MMRec]

Hello,

I am hoping to copy Rows from sheets 1-12 to sheet 13, if cell value in J is greater than zero.

I want to hard-link this data with sheet 13, which I will call "Outstanding." So, any changes in sheet 13 will be reflected in their respective sheet (1-12).

Is this possible? Thank you so much! - Using Excel 2007.

 

[MMRec]

This seems like a fairly simple script. Does anyone have experience with this?