VBA pull data from closed workbook depends upon header status !!! need help of experts

Dear expert's


I WANT PULL DATA FROM CLOSED WORKBOOK DEPENDS UPON
"HEADER STATUS VALUES" I HAVE SET OF HEADER VALUES "A1:P1" NOT MORE THAN THAT

I HAVE SOME MULTIPLE SLC_1,2,3,4,5 ETC WORKBOOK IN SOME TARGETED FOLDER(D:\Documents and Settings\Administrator\Desktop\FORUMINPUT\REBV\HEADERUPDATES))

...FROM THE TARGETED FOLDER I WANT PULL DATA RANGE OF A:Q IN Q COLUMN I WANT PULL WORKBOOK NAME (E.G) IF PULLED FROM SLC_1 I WANT SLC_1.XLS IN Q COLUMN

IN EVERY WORKBOOK CONTAINS SAME SET OF HEADER STATUS" BUT IT GET CHANGED INTO DIFFERENT COLUMN...

FOR E.G IN WORKING FILE SLC_1 HAVE SAME SET OF HEADER(A:P) BUT IN 15 HEADER STATUS COLUMN "CUSTOMER " MOVED TO 13

AT THE SAME TIME 13 HEADER STATUS COLUMN "CONTACT NAME " MOVED TO 15 "

I WANT PULL SAME RANGE EVEN THOUGH IN BETWEEN COLUMN HAS HIDE I WANT PULL DATA....

FIND THE ATTACHMENT WITH THREAD( ONE IS MASTER, REST 3 (SLC,1,2,3 IS WORKING FILE)

RESI;T EXPECTED IS IN SHEET2 IN MASTER)

THANKS ALOT