Append big Excel files into one

[terious]

Hello,

I have to append 30 Excel 2007 files, each with 6700 columns, into one. The problem is that in these files the columns are not in the same order(the column names are the same in all the files). Im having Python27 with openpyxl, Win7, MS Office 2007, MS SQL Server 2008.
Any ideas are appreciated!

[pyTony]

I posted code snippet for sorting data by header row:
Code Snippet: Sorting columns of data by header name