Automate the searching for a value and copying the row into another worksheet

[Legacy 447442]

Hello all,
I am looking to automate a repetitive process, i have tried multiple times to get something to work with no success.

Problem:
I would like to automate the process of copying any rows from multiple worksheets that contain the word "ESCALATED" in a column into a new Worksheet named "Escalated".

Workbook Setup:
I have a Workbook that has worksheets named the days of the week.

The worksheets have multiple Columns with headings in Row 5.

The first Row that contains the data that i wish it to search from is in Row 6.

The term "ESCALATED" will only appear in Column "E"

End Result:
The term i wish it to search for is "ESCALATED" that will only appear in column "E" on multiple worksheets.
I then want the rows that contain the term "ESCALATED" in Column "E" to be copied to the worksheet named "Escalated"

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...e-row-into-another-worksheet.html#post5118655

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.