Formula to automate sheet name

[diamondjoechubbs]

It has been a while since I've used excel in a job setting, so forgive me as I am trying to dust off the cobwebs.
Every morning I import data from a report into a new sheet that I name simply with that date. I then use the following formula to pull the information I need from that sheet into my data tracking sheet =XLOOKUP($D2,'10.23.2020'!$A:$A,'10.23.2020'!$D:$D,"D.N.W.")
Is there a way, since the sheet name is only the date, which is also the first row on that spreadsheet, to automate the sheet name so that it pulls it every day so that I don't have to find and replace?

 

[Joe4]

Does the value in cell I1 EXACTLY match the sheet name?
Are you sure it is text, and not a date with a special format applied to cell I1?

 

[diamondjoechubbs]

In what way is it not pulling the correct data?

when I type in 10.23.2020, it does the search and pulls from column d, the above formula doesn't pull the correct data. It should pull 0:00:41 and it pulls 0:00:00

 

[diamondjoechubbs]

Disregard, it worked now, thank you so much for your help, I forgot to double check the row number

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[diamondjoechubbs]

Thank you so much everyone for your help