I am interested in creating what is essentially an automated summary
worksheet in a workbook that would take data from multiple other worksheets
in the same workbook. My goal is to allow me to update data in sheet1,
sheet2, etc, so that it all automatically enters itself into a consolidated
summary table on sheet 7. All of the sheets will have the same fields, but I
want to be able to sort the summary data using the list features.

Instead of linking every cell in sheet 7 to every potential corresponding
cell in sheet1, can I create lists on sheet1, sheet2, etc., that essentially
export their data to a master list on sheet7? ie. If I currently have 3 rows
of data on sheet1, but expect 20 by the end of the year, I don't want sheet7
to have links to 17 blank rows within sheet1's list. Instead it would add
rows as they are added to sheet1's list. This way I don't have to leave lots
of blank rows in sheet7 that are waiting for the data to be filled into
sheet1, sheet2, etc.

Hopefully, that all makes sense. I can't find anything in the help section
that explains what I am looking for, can anyone out there help? thanks!