Formula reference cell

Hi.
I have a workbook, and everyday I track daily changes in about 20 different categories. Everyday I duplicate the current worksheet and name it whatever todays date is example 10-28-21.
Instead of changing the formula in each of the 20 cells (I just change it in one and drag down, but...) would I be able to have a field with a date so anytime I put the name of the sheet I want it reference the formula will know to look at that sheet.

I'm attaching an excel file showing this a little better. Thanks in advance.

You could try this:

=INDIRECT("'"&MONTH(E3)&"-"&DAY(E3)&"-"&RIGHT(YEAR(E3),2)&"'!E3")

To be able to copy down, in B4, the likes of:
=A4-INDIRECT(TEXT($B$3,"'mm-dd-yy'!")& CELL("address",A4))

Thank you to you both!

The formula provided by p45cal worked perfectly!


Sent from my iPhone using Tapatalk