I'm now putting data from one file into a workbook's data tab. Power query would help me move things along more quickly. My old data is pushed to the right and any cell references go with it when I drag data from a file into a spreadsheet.
Is it possible to replace what already exists? I realise that once it is initially set up as a power query function, there won't be any issues; all I have to do is reload the worksheet.