Combining/consolidating arrays onto a separate sheet

[rbrychckn]

I'm trying to get all of the rows that have J="Discontinued" onto on
sheet, pulling from set of worksheets (in the same book). I've bee
able to get all of the "Discontinued" entries out by themselves on th
same sheet, but cannot consolidate between sheets.

For example:

Sheet1
J K L
Active data1 dataa
Active data2 datab
Screened data3 datac
Active data4 datad
Discontinued data5 datae
Active data6 dataf
Discontinued data7 datag

Within the same sheet,
AE AF AG
Discontinued data5 datae
Discontinued data7 datag

Now I've got multiple sheets that have something similar, but wit
varying numbers of rows of entries. I can't figure out how to properl
recurse through them. Any help would be appreciated.

- To

 

[rbrychckn]

Can anyone help me on this one? This one has stumped me for days.

Thanks,
To