Consolidate from multiple sheets into single sheet with conditional copying

Hi, Request a help in consolidating the sheets into single sheet with conditional formating.

example

have 3 different sheets by name (Project 1, Project 2, Project 3) with similar columns, goal is to get the data into the summary sheet for a given status. common field for filter is Column E.

enclosed the workbook for reference
thanks
Karthik