How to consolidate different Excel sheets?

[ExcelGebruiker]

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

 

[Don Guillett]

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?

more detail

 

[Laurence Lombard]

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.