What kind of problems are you having?

It might be easier if you just put a formula on each sheet in the same cell like this:

X1: =--(A5="Yes")

Then, to get the count of "Yes" across all the sheets:

=SUM(White:Blue!X1)