I have a Summary Spreadsheet that brings in data from linked spreadsheets
outside of itself. Every week those linked spreadsheets change data, of
course, and when I open the Sumary I click on update.

The problem is that the linked spreadsheets only bring in the exact number
of lines from the previous week. So if last weeks spreadsheet had 57 lines
of data and this week has 80 lines of data, I only see 57 of the 80 and have
to cut and paste and link again.

What am I doing wrong? Why doesn't it just bring in everything that's in
the linked spreadsheet?