extracting particular rage from 100 excel file

[aswathy0001]

my folder having 100 of excel files (each file have only one sheet but its names are not same)
if i have the path and file name in a workbook ("Anil.xls) at A range can pull data from that closed 100 excel files range a1: f1 to my ("Anil.xls) at b1:g1?

 

[arthurbr]

See http://www.mrexcel.com/forum/excel-...l-closed-book-different-monthly-versions.html