Search across multiple sheets

Hi All, I have a workbook with approx 40 sheets. Each sheet cover columns A-I and rows 1-22. Column E contains currency values. I need a function whereby a new sheet is created and returns the entire row if column E is above a certain value. for example. if column e values is >€1000 then all of row 18 is transcribed into the new sheet. Have searched various forums and can't find anything to fit.

Any help much appreciated.