Comparing two worksheet data

Hi,

I need help from you guys. I have 1000's of records in two different excel sheet. Both the excel sheet have record name (record parameter with minor difference). I want to compare the two excel worksheet data using record name and fetch the required data. At present, I am using Filters to do the process. Because there is 1000's of records, it is very difficult for me to do that. I even searched for "compare excel plugin" using google. But it doesn't solve my purpose.

Pls. find attached the excel sheet. The excel sheet has two worksheet (Data1 & Data2).

Data1 consists of Date, Position, Target, URL, Imp
Data2 consist of Date, Position, URL, Profiles, Ref. by

I have to copy the Profiles & Ref Id details from data2 to data1 by mapping URL. I am using filter, but it is difficult to handle 1000's of data. Is there is any plug in or macro to do this process. Please Help! Thanks in advance