Data Move to Master from sheet1,sheet2 vba depends upon column heading value

Dear expert

I have workbook with 3 sheets Master,sheet1,sheet2 I want macro to pull data from sheet1 and sheet2 depends of master sheet heading values

In sheet1 set of heading is similar to master headings but in sheet2 set of heading slightly missing 3 headings

E.g Acutal Heading is 14 of master sheet and In sheet1 is 14,in sheet2 is 11....3 is column heading missing

i uploaded sheets which is marked as yellow color in sheet2,as result of after macro done

find the attachment of file

thanks all

Hi breadwinner. Assuming that sheet "MASTERDATA" is blank except for the column headers, try:

Please Login or Register  to view this content.

If i extent the extra range of column heading or change column heading , or if i add new sheet next to sheet2 how its works
for e.g see the attachment where marked yellow color headings look newly added column's

code column header consider from master sheet to sub sheets, what ever avaliability of column header in sheet1,2,3 should move to master headings rows. with out limit of range...

Try the attached. The code works if the headings on each sheet should exactly match the headings on the master sheet