Clean up and organize the format and data in excel file - Chinese Real Estate Companies

I need you to format and clean up this excel file "Property Most up to date". There are 76 worksheets, all with different information about Chinese real-estate companies on them. I have created another excel file "Categories", which includes the standard columns i want. I need you to format each worksheet so that the information is put into these standard columns. Some worksheets will not have all the information, do not worry about it, just make sure the ones that do have the information seen in standard columns, you move the information into those columns. If there is any extra information left over, move it to columns to the right of the standard columns. I need you to convert information from rows into columns. For example, worksheet 2 says: Hotel Property: Project 1 Project 2 Investment Property: Project 3 Project 4 Project 5 etc I would need you to create a column which says Type of Property and put in Hotel for projects 1-2, and Investment for projects 3-6. So the rows should all look the same, there shouldn't be any extra headings or other information in the rows that doesn't look like the other rows. All that information should be reformatted to look like columns. You may have to add columns and create input for the columns. Converting row to column for project type, make sure to be specific about what type of project it is: retail residential commercial/office hotel any combination of the above 4 So there should be 4 factorial combinations Rename each worksheet with the first word of the name of each company (1st 2 words if there are duplicates) Also, link the code next to each name of the company on the control worksheet to the cell right next to the name of each company on the individual worksheets. Overall, i need this excel file standardized so i can start doing some analysis on it. Thanks