In the attached, 2 offerings:
1. A button which runs a macro blah which you'll need to tweak in 2 places to refer to the right text file - see notes in the code.
2. A Power Query solution that also needs tweaking to identify the text file; this picture is an attempt to show you what you need to do. Once that one-off process is done, just right click in that small green table and choose Refresh.
Try changing to:
You shouldn't need to add any references.
Otherwise, why not stick to Power Query?