155827 Excel file combination

I've about 6 excel files. Each file got records ranging from 100 to 1000. I want to combine all the files in to one. Also I've need you to mention the duplicate records in the merge file. In one of the files it contains about 1000 records in which there is a filed "Phone number" which currently contains phone number, extension number, fax number, mobile number. I want to separate all of them in to different fileds. I need to finish this project in 5 hours time. (Itz so easier, ofcourse) Only flat rate bids plz.