Worksheet_Name! based on Cell Value

I have a worksheet template that I am constantly adding new tabs to; but I want a summary tab that references all tabs, and can easily add a reference to tabs as added.
A majority of the tabs are all identical; literally made as copies of one another for each day of data entry. I then want a summary tab that is pulling four values from each tab to display. Then as I end up continuing to copy additional data entries per day, I want to be able to easily expand the summary tab to include the additional sheets.

Since each day is a different day of data entry, then they are all named based on the day's date (e.g. 2022-06-01, 2022-06-02, etc.)
On the summary tab; I can have these organized out in columns starting by date. But the values underneath would be ='2022-06-01'!$O$33, etc. I would like the worksheet_name! '2022-06-01' to instead reference the values in my top row, where that same value is also input. But doing =C2!$O$33 does not work. Is there a way to extract the value of the cell to utilize in place of the worksheet_name! in an excel formula? This way as I keep adding tabs, all I need to do is copy-paste C2:C4 into __2:__4 and update the date in __2 for it to reference the other values accordingly.

Works. Thanks.