Pull data from multiple sheets to one sheet if criteria met

Hi all,

I have a spreadsheet with 12 tabs (one for each month of the year). What I need is a macro/function that on execution will pull all rows from each sheet that has the word "overdue" in cell E from E9 down. I need the whole row of data being taken into a new sheet.

So for example, in each sheet there could be the word overdue appearing in 30 out of 500 rows I need those complete rows (A to Y) being put into another sheet for ease. At the moment I am filtering each sheet and copying and pasting into a new sheet for each bloody sheet (LOOOONG way).

The worksheets are titled: Jan 14, Feb 14, March 14, April 14, June 14, July 14, Aug 14, Sept 14, Oct 14, Nov 14, Dec 14

Many thanks in advance

Hi saarang

Yes Macro VBA approach is totally acceptable, especially if I can just assign it to a button as it would be a simple approach to explain to others how to run the report.

Thank you

I'm sorry but I don't know what part of those codes I need to change to fit my requirements. I am only a very basic beginner with VBA.