Import data from adjacent workbooks

[YasserKhalil]

Hello
I hope to find a quick solution of my request please as I need it at once

I have four workbooks in the same folder
One named (Summary) this is where I want to import data .. In this WB there is a table already done ...
All what I want to do to import data from other adjacent workbooks (Test1 - Test2 - Test3) from sheet named with the same name in these workbooks named (Export).

In WB(Summary) Row (10) to be copied from WB(Test1)/Sheet(Export) Row(10) as source.
In WB(Summary) Row (11) to be copied from WB(Test2)/Sheet(Export) Row(10) as source.
In WB(Summary) Row (12) to be copied from WB(Test3)/Sheet(Export) Row(10) as source.

Here's an attachment