Rows adjusting to fit amount of data?
 

Hi!
I am creating a summary sheet that organizes data from multiple other sheets
in the same workbook. Each sheet has totals that are automatically entered
into one row of data on the summary sheet. These rows are then totaled at
the bottom of each column. There are four rows of totals on the summary
sheet grouped together at the very bottom. How can I adjust the position of
these four rows so that they are consistently at the bottom of the summarized
information, whether there are 5 sheets worth of data or 50?
Thanks for your response!
-Kai