search tabs and return results

I would like to summarize all "yes" respose contained in 15 tabs. See the attached.

I would like results to be returned to the "summary tab" when user answer "yes" in the signficant column in the "process activity 1 through 15" tabs. If the answer is yes, I would like to pull the process name, aspect and impact detail.