need a bit help to get the following :

I have a sheet whitch contain 50 small tables under eachother each 10 rows with header. with productname.
the 10 givings in each table are regulary updated from the internet with a time running macro.

now i want that when the 10 th row saying sold more the 5 pieces, he copy that table and put it in a new sheet
I think I can not use autofilter otherwise I loose the rest of the table,
so if cell 10 (20, 30, 40 ..) is >5 then
Range(ActiveCell.Offset(0, -6), ActiveCell.Offset(-10, -2)).Select
Selection.Copy
Sheets("StockAlert").Select and paste it there everytime above the last paste.
if he update , maybe 4 reach the condition, so he need a do loop ?
Thanks
Chris