Multiple Worksheets, multiple lines and summarizing into one works

[smiley61799]

I am working with a spreadsheet which can have multiple spreadsheets all
formatted the same way. Now although these sheets are all formatted the same
way some may have 1 row of data while another may have 10 rows of data. I am
wanting to incorporate these into a summary worksheet at the beginning of my
spreadsheet which will list all of these rows automatically. What kind of
table or formula would I need to look into to make this happen?

 

[Billy Liddel]

Another solution may be to try Consolidation in the Data menu