Excel - multiple dynamic names sheets and want to roll-up values from multiple sheets

I have a spreadsheet that needs to be done every friday.
I got it to create from the template, rename the worksheet to date and userid
dropdown values validation for each Friday with Yes or No


The issue:
now I'm trying to do a rollup for those spreadsheet as to, how many 'Yes', 'No' and nothing.
I have been trying but not getting any positive results, or getting errors.

Can anyone help me.

Thanks in advance

Maurice