Problem: I have a workbook with three different worksheets in it, sheet1,sheet2,sheet3. All have similar data, but in different column headers that are in different order on each sheet.
Sheet1 has columns like first_name, Last_name, Phone_1, Phone_2
Sheet2 has columns like Custfirstname, Custlastname, Email, Phonenumber, phonetype, Phone2number, phonetype
Sheet3 has columns like Agent, Branch#, Customer First, Customer Last, Phone Cell, Phone Home, Phone Work
I want to create a master sheet and consolidate the data from all three sheets into a master sheet with new headers of my choosing. I want the end results to be something like:
MasterSheet has columns Branch, First Name, Last Name, Phone 1, Phone 2, Address, Email etc
Bookmarks