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?