user Roee Adler said:
Google Spreadsheet: aggregating rows from multiple sheets
In a single spreadsheet, I have several sheets containing data that is structured in the same way. I would like to create a new sheet that will dynamically include all the rows from several other sheets.
following is a solution using the VMERGE (custom written function by ahab) available in Script gallery from within Google spreadsheet