Macro to match multiple columns in different sheets.

As in the attachment I have three sheets where sheet Report sheet has the data from row 2 and I have placed the headers of sheet compare so that to match the corresponding headers. (Ex: in report sheet Base price column is called as $ W/0 Cu in the header).
So what I want is a macro which should run and check for the part number in report sheet (Without Zeros) in column A and then in Column B.
If found in column A then it should match the highlighted headers from corresponding sheets and if it is matching with all the highlighted headers from sheet reports and compare then in outputsheet it should display the part number and whether it is matching or not.
Please consider the first part number only when comparing and you can ignore the duplicate numbers. (Fist part number must match)

Please let me know if you need any further clarification and help me.

IS it difficult? Sorry for the trouble ...Please help me if possible

First the partnumber (without zeros) in the sheet Report to be checked in column A of sheet Compare (Ref P/N) and if not found then in (New P/N). once it is found then the following should compare.

From Report Sheet "daily capacity" and in compare sheet "daily capacity "
From Report Sheet "DUNS Number" and in compare sheet "Manf DUNS"
From Report Sheet "SHIP from DUNS" and in compare sheet "Ship DUNS"
From Report Sheet "Base Price" and in compare sheet "$ W/O CU"
From Report Sheet "Copper Weight" and in compare sheet "New CU (LBS)

If all the cell values for that pirticular Part number matches then, in sheet output it should give that Part number and match in the adjacent cell and if not matching then the part number with adjacent cell as not matching

I hope i am clear this time.

Please note that in report sheet the same part number will be repeated multiple times and you can consider only the first part number ignoring the duplicates

jraj1106, I think i have helped with the information which you wanted and I hope you will help me. Others also, please help me

any help!!

I am sorry...

Any update please help me...