Does anyone know how to consolidate different Excel sheets containing the same basic template (i.e. same column headers but with a varying numbers of rows) into one Excel sheet?

On Wednesday, May 2, 2012 5:22:26 AM UTC-5, ExcelGebruiker wrote:
Does anyone know how to consolidate different Excel sheets containing
the same basic template (i.e. same column headers but with a varying
numbers of rows) into one Excel sheet?




--
ExcelGebruiker

more detail

On 02/05/2012 12:22 PM, ExcelGebruiker wrote:
Does anyone know how to consolidate different Excel sheets containing
the same basic template (i.e. same column headers but with a varying
numbers of rows) into one Excel sheet?




Say for example you have spreadsheets for each month of the year: Jan,
Feb, Mar etc, all with the same column headings. Then I would create a
single sheet with an extra column titled "MONTH" and populate that
column with the title of the individual spreadsheet: Jan, Feb etc. Then
you have all the data in one sheet, with the MONTH column specifying
which section it has come from.