I have a multi-tab workbook with several checklists.
Once item on list is complete owner puts YES in status box and cell turns
green.
I have a combined list of all the tabs on another sheet.
I need the combined list to pull the YES response from each individual
checklist tab and also turn Green.

Conditional formatting will not allow cross worksheet actions. Is there
another way to pull all the YES data into the overall checklist?

thanks
Trese