It would seem the only way you can match up any of the data in one excel worksheet to another is by name. If this name data is not perfectly entered (some sheets spell the name differently, more than one person with same name etc., you will have problems with this data. Assuming that you have good data to work with, you can start out with using names as the key for matching records and then, after data is imported and linked, you can transition to using ID numbers in place of names.
For data like your phone number issue, the linking process is the same, but you'll need to use either an auto-enter calculation during import or a replace field contents operation (with the same calculation) after import to extract th enumber and category data into separate fields. The exact nature of that calculation will depend on how consistently this data is formatted in the work sheet.
Using just the one example given,
leftwords ( Numbercategory ; WordCount ( numberCategory ) - 1)
would extract the phone number and
Rightwords ( NumberCategory ; 1 )
would extract the category--but this may not work with all of your data if some cateogires consist of more than one word.