Import Text File Location

[Odderjob]

Hi,

i'm importing text files into my worksheet. (Using the function in the
data menu so that I can auto refresh, etc).
The text files are in the same location as the worksheet

Now if I copy the worksheet to a new directory, is there a way to make
it automatically look for the text files in this new directory,
rather than having to use the file explorer?

thanks in advance