Macro to Merge Data Based on Condition

Hello Dear,

I have multiple sheets with different columns, the headers are mentioned in row 3 and there are few headers which are common across all the sheets but these are not in a specific column for eg: header "EAN" in one sheet it is in column C and in second sheet it is in column G and in other column "AB". I am looking for a macro code which can help me to merge these specific columns.

It would be very helpful if anyone can help me with this, Thank you so much for taking time to reply.

Thanks & Regards,