Microsoft Query Table not populating if Document Moves

I think that I understand the general reason for this problem, but I'm not sure of a solution or an alternative.

I'm trying to create a document that will sort a list of POs as follows
Services
Goods
Other

It does this by checking if the Cost Center code matches the correct section and checks to see if it's already been paid (this is only for open invoices).

I ended up making the list of invoices a named table, then used the Microsoft Query in Other sources under the data tab to define the table that it would sort. It worked fine, and allowed me to complete the rest of the project, but now if it's moved to a new folder it can't reference the original table because the location changed. If anyone has any tips or ideas I'd be grateful.