Thinking about it, if you just want the data to show in another workbook and the location & file name of the the data dump are static you could just import in power query and then refresh each day.


You might find that power query can do some of the other stuff you do with that file as well