I have a summary sheet that gathers information from various tabs in a
workbook. Each other tab's information is listed in a new row. I may have
as few as 5 other tabs or as many as 50. This creates a set of 7 columns
that are totaled on four rows at the bottom of the sheet. These totals are
currently set at rows 38 to 41. I would like these four rows to move
dynamically to accommodate the amount of tabs I am totaling so there are not
rows of zeros displayed when there are fewer than 36 tabs (currently I have
the summary sheet set up to hold 36 other tabs and any unused rows are left
filled with zeros.) Any help would be much appreciated!
-Kai