Excel Data Manipulation

I have an excel workbook that has 157 sheets in it. Each sheet has about 15-20 lines. The report is for contact information for leadership rosters for multiple regions and offices. There are multiple roles in the report and I want to get information for only one of the roles, the team leader (designated by TL). All of the sheets are not formatted the same. While they have the same headings, the data appear differently from sheet to sheet. For example, there is an address field. In one sheet the entire address will be in one cell properly formatted with street number, street name, and suite number (if applicable) on top, and the city, state, and zip on the bottom. In another sheet the address may be broken into two, or even 3 cells. Same with the email cell. The headers of the sheets are: Reg#, Region, Market Center, MC#, Role, First Name, Last Name, Role Start, Phone, Email, and Address. I am looking for one file that has all of the people identified with the role of TL, along with all of the information associated with the record properly formatted (i.e., one cell for each piece of data, with address formatted as street number, street name, and suite if applicable on top of city, state, and zip in the same cell). Please let me know if you can do this, and about how long will it take? Thank you