Compare Price List

Hello Again,

I am looking for VBA Macros to compare 2 price list. I am trying to achieve the following.

1. Script look in sheet one i.e. Old list for duplicate if it is their it should display in 3rd sheet i.e.duplicate with sheet name and row number
2. Script look in sheet two i.e. New list for duplicate if it is their it should display in 3rd sheet i.e.duplicate with sheet name and row number
3. Script look in both the sheet for duplicate values it it is there then it should display in 3rd sheet i.e. duplicate

Also it should count the number of records on each sheet in column F1. If possible can we display the work % while checking both the lists.

Sample file is attached which will give you more clarity of my request.