update new rows from linked data

Hello Excellers,

I have one spreadsheet sourcing data from another. I would like extra rows of data in my source spreadsheet updated in the destination spreadsheet. I'm using the = command to link a range of cells, and that range needs to change as extra rows are added in the source file.

I've seen another persons query regarding my problem here: "need to link external worksheet", and the solutions provided aren't quite what I'm looking for (solutions involving copying the entire tab). So I was wondering if there was any new thinking on this?

Happy day to you all!