Hello,

I have a workbook with 235+ pages and counting. The pages are named Sheet1,
Sheet2, etc. to keep it simple.

I need to know how to find out if the word 'yes' was entered into the same
specific cell (B43) on each sheet and have the total number of times this
occured show on my summary sheet, automatically updating as data is entered
and new sheets are created. Is this possible?

Thank you,

tgcali