Is this a new excel file everytime or is data being appended to it? I'll assume it's data being appended to the same excel file. If this is the case, you'll have to make a marker on where it last left ...
Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...