Worksheets reorganization and formatting

Hi!
I have an urgent problem and here it is: I have created several hundred worksheets, all saved with different names but have the same columns. What I need to do is to automatically rearrange the columns in the same order for all files on the fly. i.e. I need to "transform" all old files with the same columns to new files with the same file names into new files with the same old colums but having a different column arrangement in the new files. Is there a macro or procedure that I can ues? Please help!!!
My e-mail is: [email protected]