help on vba code to pull data with conditions ,filename,avoid header,unfiltered data

dear expert

knock your door for help!!!!

i have master sheet through vba code i pull data from sub-files where kept in separate folder.

1.HERE I WANT PULL DATA EVEN THOUGH THE WORKBOOK DATA GETS FILTERED IN RANGE. I WANT PULL FULL RANGE WHERE I ASSIGNED IN RANGE (A2:BE7653)
E.G THE DATA IS FILTERED IN WORKBOOK-A.XLS I WANT RETREIVE DATA ALL DATA UNFILTERED DATA ALSO.. TO MASTER FILE

2.SECOND I WANT ADD SLC FILE NAME FILE NAME FROM WHICH FILE THE DATA BEEN PULLED

E.G IF DATA IS PULLED FROM A.XLS I WANT ADD NAME OF WORKBOOK WITH EXTENSION LIKE A.xls IN COLUMN BG:BG CELL

3.I WANT PULL DATA WITH RANGE START FROM A2:BE7653 I WANT AVOID HEADING OF EACH FILE
WHILE PULLING B AFTER A I WANT PULL WITHOUT HEADING A1:BE1 SHOULD START FROM B2

FIND THE ATTACHMENT & CODE IS ENCLOSED

Please Login or Register  to view this content.

atleast any one can solve any one of these 3?