once you have the consolidated data in one sheet-- can you not sort the data
to get it into the order you want (or use a pivot table)?

"Dave" wrote:

I'm consolidating 3 worksheets into one by using Excel 2007 data
consolidation. The worksheets have product numbers in column A and sales
figures in columns B, C & D for Jan, Feb and Mar. The worksheets are in
product number sequence. Not all product numbers appear on each sheet, so I
consolidate by category using "labels in left column", "labels in top row"
and "create links to source data" to create a consolidation sheet in outline
form. The problem is the consolidated worksheet is not in product number
sequence as I need it to be. I have books on Excel 2007 and Excel 2003 and
their consolidated
worksheet examples are not in sequence either although their input sheets
are. Any ideas? Thanks.