Data Parsing? Awk? Excel? Power-BI?

from what I've read PowerBI should be able to do what you need

you will still need to provide updated location in case the file move - M can read all files from folder, so you could set up a flexible logic, but it will need specific input for references to work

FYI - from the data transformaiton perspective it can all be achieved in the same way in Excel by using Power Query (Get & Transform in Excel 2016), it's more how you set up the process than the tool itself. In a sense it's even more flexible cause you can use VBA to read the current file location and seek latest version of data source in the same folder