------ Register to get rid of these "In Post" ads! ------


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?

------ Register to get rid of these "In Post" ads! ------


Hi,
there is a possible solution at Merge cells from all or some worksheets into one Master sheet

__________________
Cheers -

------ Register to get rid of these "In Post" ads! ------


Another solution may be to try Consolidation in the Data menu


"smiley61799" wrote:

> 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?