vba to export data from single wb along with existing 2 sheet!!

Dear experts

I have N number of multiple closed workbooks in desired path with sheet list like A,B,C...etc

i want vba to export data from single closed workbook sheets Acc&Sub acc depends upon unique value of H:H column of closed workbooks A,B,...etc
along with existing sheets FY-15 & FY-16

for e.g In workbook A sheet(List) H:H column Unique values are TE001, & TE002. I want export TE001&TE002 from Datafile.wb Acc&Sub acc sheet.
at end copy FY15 & 16 sheet to all workbook.

In workbook B sheet(List) H:H column Unique values are TE001,TE003&TE004. I want export TE001,TE003,TE004 from Datafile.wb Acc&Sub acc sheet.
at end copy FY15 & 16 sheet to all workbook.


find the attachment.. You may understand. i want run macro in blankworkbook.
A,B,C....Files stored in C:\Users\Julie\Desktop\FY16
DataFile stored in C:\Users\Julie\Desktop\Data