Copy multiple rows depending on value of cell.


I'm working on a excel-book where it is 3 sheets of data. In the 3rd sheet I want to be able to type in e.g. Ior and then get all the rows from sheet1 and 2 to be collected in the 3rd sheet. The value to look for is always in F:F and the sheets are 10 columns wide (J) and sheet1 is 154 rows and sheet2 236 rows. How should i make that happen?

Best Regards
Oscar Andersson