Report that updates weekly

Hi ld17 ,

I would try a bit different approach than just renaming files.
If your data source is SharePoint folder, you can take advantage of some additional columns you get from Sharapoint, for example Date created or Date modified as you can see bellow:

You can filter the latest file based on Data created:

And in a last step you go with Combine in the first column:

Once you finnish combine, you will get your data and you will always get the latest one:

Just be sure you use same name of Excel sheets in all files and you should be fine.