I am building a shift tracker where there is the main metrics dashboard on the first sheet/tab and locations/percentages featured in the succeeding sheets which are labeled as dates (ex. Oct 3rd).

The main metrics dashboard has these locations and percentages posted in the form of mini-dashboards in succession by date. Each dated mini-dashboard on the main sheet has a formula similar to this one under categories and numbers it has listed ='15 Oct'!A1, ='15 Oct'!B1, etc.

How do important the data from the succeeding sheets to get this?

I tried using =date on tab command V+Command B, but have been unsuccessful in importing the correct information from the dated sheets onto the main dashboard.

I have Microsoft 365 2020 for Mac OS if that's any help.

Thank you in advance for your help!