Cut and Paste Rows from Worksheets to the Summary worksheet based on a certain condition

Hi all,
I'm pretty sure this is a simple fix, but being new to VBA, I am lost in the sauce.
I'm trying to cut and paste rows from the Worksheets into the Summary page after the project is completed to provide a running list of work done for the year.

The number of worksheets to pull from will be many (expecting 10-15 sheets eventually).
All of the sheets have roughly the same column header names that are in the exact same spots. The number of rows to each sheet is flexible.
The condition to be met is Column E (Completed)=Yes. If that condition is met, then the entire row should be cut and pasted from its respective worksheet onto the Summary sheet.
On the Summary sheet, I would like Column A to list the corresponding worksheet from which that row originated. An example file is attached.

I've tried several different codes, but I am just not coming up with anything that works.

Thank you so much!!

Hi dj27jaz,

Please find the attached workbook and have review and let me know if u have any question.

Thanks - Naveed.

Thanks Naveed, works perfectly!

your welcome !

If ur solution got resolved then please mark this thread as Solved.

Goto - First Post - Click on Thread tool - then select mark this thread as solved.

Thanks - Naveed.