Efficient data sourcing from other worksheets.

Hello all! Hope you are all doing well!

I am trying to source data from 10 worksheets. The data I am checking is the date on a specific cell of each worksheet and comparing it to today's date.

I have the following formula working:

=SI(DATE(ANNEE(Marlon!D4);MOIS(Marlon!D4);JOUR(Marlon!D4))=DATE(ANNEE(Sommaire!Y7);MOIS(Sommaire!Y7);JOUR(Sommaire!Y7));1;0)

The problem is that this method is highly inefficient because I have 32 such specific cells per worksheet and the 10 worksheets to pull from. I had previously finished expanding the formula over cells for the first worksheet (Marlon) and wanted to directly copy what i had filled out into the cells next to it. The problem is that no matter what i did excel kept changing the formula. And even at that i would still have to go back and change the name of the worksheet that the formula is referring to another 864 times.

To lay out exactly what i am doing:
I have 10 identical worksheets. I want to check the date on 32 specific cells of each worksheet (the sheets are identical so it is always the same cell on each worksheet that i am referring to) I have the page organized into two macro columns such that the cells i am interested in are at D4 and K4. And both columns repeat downward 16 times such that the next cells i am interested in are D14 and K14. (the next set is D24 and K24).

I am then comparing the retrieved date to a cell that has today's date on it and checking to see if the dates are the same. If they are return one. If not return zero.

Is there a more efficient way to do this?
Thanks for all your help!

Dom

what is that? an operator or a function?

it seems to work but it still doesn't solve the problem of how i copy the formula, though it is much faster to write.

That is fine for copying the rows down but what about copying along columns where i need to change the referenced worksheet?
for example, Column B2 and C2 refer to Marlon!D#4 and Marlon!K#4 respectively, but now column D2 and E2 need to refer to Michael!D#4 and Michael!K#4?
Also, is there a way to have the portion of the formula that refers to Sommaire!Y7 always be Sommaire!Y7 when i copy it? There is a simple workaround for that* but i was just wondering if it is possible.

*The simple workaround being that i copy Sommaire!Y7 down a column to Y8, Y9, etc, it being just a reference to today's date.

That first suggestion in the last comment works perfectly!!! All my worksheets have no spaces so i don't need to worry about that though!

Thank you so much for all your help! You obviously had a reasonable understanding of what i need! Also thank you for the thing about $ being an anchor I didn't know the symbol meant that. (i'm used to $ being at the beginning of variables in coding to create it)

You are a genius!
Have a great weekend!