I currently have a Google sheet with an Apps Script and timer that generates a new sheet once a day, with today's date as the name. The new sheet is automatically named "11/1/2024", tomorrow's sheet is automatically named "11/2/2024", etc. Using IMPORTRANGE, I want to import the data into a separate sheet file. But I only want it to import information from the most current sheet in the first file, the one with today's date.

The way I currently have the IMPORTRANGE formula set up, it is referencing a specific sheet name, i.e. =IMPORTRANGE("link","11/1/2024!A1:A50"). This works great for a day, but I want to implement a formula that will dynamically update each day to source the sheet with that day's date. I've tried implementing TODAY instead of the sheet name into the IMPORTRANGE formula, but it doesn't work.