Finding words and copying adjacent cell

Hi,

I need some help with a formula. I have a sheet1 with a bunch of data and I want my sheet2 to find a specific cell in sheet1 if that row in sheet1 contains a word. For example: If the word "red apple" can be found somewhere in column A in sheet1, then take that row containing "red apple" and its value in column B and copy it to cell A2 in sheet2.The problem is that there can be a "green apple", "blue banana" and a bunch of other words, that is why the formula needs to search for a specific combination of words (I used A1&" "&B1 where A1 is color and B1 is fruit). When the formula finds a word, it should take the value in an adjacent cell in the same sheet and copy it to another sheet.