Summary sheet, copy entire row if a cell criteria is met

Hi,

For each of the tables, I have added a column (the first column) with the name of each sheet you used in your file.

Look at the Sheet named: Outstanding Jobcards where I used Power Query. This sheet gives all the INCOMPLETE data for all the sheets you have in your workbook.

If you want to see INCOMPLETE only for sheets that contain the word ACTIVE then in cell A1 of the Outstanding Jobcards sheet click on the small arrow that is located to the right of this cell. A window will open. Select Text Filters then click on Contains. In the window that opens write ACTIVE. This way you will have filtered only the sheets that contain the ACTIVE sheet.

I am also attaching the file that you can download.

Hope this helps.

IlirU

https://1drv.ms/x/c/511e91319deee91f/IQBNS6ic9Z6kSI9BMux53l9VARsA2q9zLTUbKr0WX9vzCyk?e=9eoAy2