Hi, I looked at few threads similar to this, but I couldn't find what I was looking for. So I need some help writing a macro.

In my spreadsheet I need to find the following:- In the Data Sheet, if the word "Apple" is detected I want the entire row to be copied to the Apples Sheet. In the same macro if the word "Orange" is detected the entire row should be copied to the Oranges Sheet. The same if "Pears" is detected the entire row should be copied to the Pears Sheet

The headings don't need to be copied as they are already in place.

I hope someone can help me and I apologies if I overlooked something similar to this.

Thanks in advance!

Example.xlsx