I have a series of named tables in a workbook - Planner.xls - saved on OneDrive.
I then have a workbook - Timesheet.xls - saved on OneDrive, which uses a power query to draw data from the named tables in Planner.xls, saving this in named tables within Timesheet.xls.
The query itself updates to...