Changing to latest Source

Hi all,

I am extracting data from an excel file which will constantly be updated with the revision number and date. 

For example, I made a change to the data source yesterday and the file is saved as "Filename_revA_01Sep2020"

When I make a change to the file today, the file name will be saved as a different file in the same folder as "Filename_revB_02Sep2020"

Is there any way I can automatically extract the data from the latest date/revision without having to constantly change the data source every time there is a name change? Can the "advanced options of changing file source help me with that?

Thanks in advanced for your help.