My workbook has many sheets, each contains part no and selling price of
special customers:

A B C
Partno Customer Unit Price (header)
xxxxx yyyyy 999.99 (data)

As and when there are new customers, a new sheet will be added. The name of
the new customer will be indicated at the sheet tabs.

I need to consolidate all these sheets into one and sort by part no.
Let's call it consolidated sheet - 'Consol' and it will be placed at the
front.

How to have macro that will do the consolidation, bearing in mind that new
sheets for new customers are added periodically?

Or for those who prefer formulas:
Excel 2007
http://www.savefile.com/files/1885636