Display Excel Sheet Based on File Name

Hi,

I have a Sharepoint folder which contains a number of Excel Workbooks, each is named by date (eg. 31-JAN-24)

I would like to display the relevant sheet on the relevant day. I currently have embedded the Excel Sheet on the page using web parts, but manually changing this everyday isn't feasible.

Is there a way of getting Sharepoint to select and display the relevant workbook when the dates align?

Thanks,

Ben