Trying to get a macro that would match up 3 sets of data

I am trying to match phone logs against data that a user says they have called. One sheet contains the phone logs, the other sheets contains the user info that has when they said they called and what number they called. I need to return in the 3 columns in the sheet if it finds the phone number against the call log, how long the call lasted, what # was called, and what date it was called on. Another issue is the phone number can be altered on the call log, so one would have "555-555-5555" but the call log could have it as +1 (555-555-5555). Any ideas?

Sheet posted is basically what i want to happen, thanks as always everyone!

New examples to use

Originally Posted by beepbeep27

I am trying to match phone logs against data that a user says they have called. One sheet contains the phone logs, the other sheets contains the user info that has when they said they called and what number they called. I need to return in the 3 columns in the sheet if it finds the phone number against the call log, how long the call lasted, what # was called, and what date it was called on. Another issue is the phone number can be altered on the call log, so one would have "555-555-5555" but the call log could have it as +1 (555-555-5555). Any ideas?

Sheet posted is basically what i want to happen, thanks as always everyone!

EXAMPLE #1.xlsm

Hey, this is fl4ke from reddit. I wrote a macro that cycles through each sheet using the named first one was the master sheet and filling in the data below that. If you want to utilize this on your data it will need to be in a similar lay out and you'll have to clean up the numbers so they match the ones on master sheet (I didn't build in any functionality to clean it up).