HI all..

The "name" is a file for each office "South_Office.xls,
North_Office.xls, ...up to 8 files), the target range
is "C3:G3"... and paste data in one row :

"Target.xls"

-A---B----------------C-------D-------E------G-
01--South_Office----"G7"-----"G8"----"G10"---"F2"
01--North_Office----"G7"-----"G8"----"G10"---"F2"
01--Central_Office--"G7"-----"G8"----"G10"---"F2"
02--South_Office----"G7"-----"G8"----"G10"---"F2"
02--North_Office----"G7"-----"G8"----"G10"---"F2"
02--Central_Office--"G7"-----"G8"----"G10"---"F2"