Excel automate VBA data selecting unique products, duplicate and best duplicate Macro

Please check the description file Check the attached file: "Global_Template_for_project" = There are several sheets in the book. For product supplier products, we called "PROVIDER 1, 2, 3, 4, 5....". In this sheets I will fill manually all data related with products. The main product identifier is "EAN" In this file There are also a sheet called "MAIN DASHBOARD" - One button will select all the duplicated products from PROVIDERS, , comparing EAN product reference; - One button: will extract to "UNIQUE DATA" Sheet all EAN (product reference) that are unique among all providers - One button: will extract to the sheet "BEST PRICE DUPLICATE DATA" only the best duplicated in price. This is not a job from the beginning: You will find all those functions/macros in another attached file called "file 1 and 2 joined" but in this, I am not using several sheets, to put provider product data, but only one sheet (front). If you take a look a t this file, In sheet "Dashboard" you can select duplicates all over the suppliers; extract unique for a sheet; extract duplicates with best price only checking EAN identifier. The big difference: Instead of extract 3 fields (EAN-STOCK-PRICE) I need the extration of all the fields previously filled (description, categories, namess,,,,,,) Please mention in the end of your proposal EAN