Thread: If Row=Apples then Move row to "apples" worksheet

I work with a massive workbook, each month I have to input new figures then move certain ones to a new sheet within the same workbook. I need a formula that states:

IF Column 2 = Apples then move row, columns a thru j to sheet "apples"

I am not a visual basics person so detailed instructions are needed.

Thank you in advance.

Hi
I know how to do this but the formula is quite a mouthful.
Send an example spreadsheet so I can add the formula to it.
eg:
=IF(ROW()<=COUNTIF(ALLdata!$B:$B,"apples")+1,INDIRECT(ADDRESS(MATCH(VALUE("apples"),ALLdata!$B:$B,)+ ROW()-2,COLUMN(),,,"ALLdata")),"")