Will try to get you som sample code during lunch, but in general:
for each sh in worksheets
autofilter(column J 0)
copy visual rows
paste to bottom of target sheet
next

"Toncat" wrote in message
...
Hi
I want to copy rows depending on columm criteria (Columm J 0) from 10
different Sheets, into one Sheet. Hope that someone now how to do it.