I have used the Consolidate feature in Excel 2010 to create an aggregated view of 4 identically-formatted worksheets in the same workbook. It works fine, but when I expand each of the outlines the name alongside each sub-item is the name of the workbook - i.e. all the names are the same, because all of the worksheets are from the same workbook.

Is there any way of changing the content of the outline so that the label of each sub-item is the name of the associated worksheet from which the data was consolidated? (i.e. so that I can tell them apart)