Within a single workbook, I have 12 worksheets called, say,
"Worksheet A", "Worksheet B",..... through to "Worksheet
L", (being departments for example) which contain common data tables
and alike data. In each worksheet, row 1 is a standard set of column
headers and this is common across all 12 worksheets. A worksheet may be
completely blank/empty, however, should there be no data for that
particular department.

I need to merge all of these worksheets into a single worksheet within
the same workbook called, say, "Consolidated worksheet" which has
the single header row and all of the data in a single combined table.
Is there a macro that will do this automatically for me?

Thanks for help/suggestions.