Merge data based on condition

Hello,

I have multiple sheets with different columns, the header is 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 "Age" 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.