Import data from adjacent workbooks

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

Please Login or Register  to view this content.

Thanks sir for help
Your code seems to be as a result of recording macros
The problem is that the number of the adjacent workbooks to the main WB (Summary) is variable >> may be four five or six as a a maximum
And I want to paste as values because these ranges contain formulas

Another important point is that source WBs should be closed .. Copying should be from closed workbooks
Hope it is clear now

I need this code for my work please help me ..

Thanks for offering help Sir
I tested the code but there are errors .. I declared variables and tested again but nothing happened..
I thought files should be open so I opened them and test the code again and nothing happened

I have fully tested this with your Data and it all Works.

What errors are you getting?

Have you changed the Address of folder like instructed?

Thank you very much
It worked now efficiently..
Just one point to complete this wonderful code
I don't want to be bounded to specific path . In other words I want to import data from the files in the same folder without using the path
C:\Users\JeRi\Desktop\New Project\

Thanks advanced

Briefly I want to do that in the same path without typing full path to be able to use it in any directory

This will use the current location of the summary workbook as the Path:

Please Login or Register  to view this content.

If this Solution answers your Question then please mark this Thread as "Solved".

Top of Thread under "Thread Tools"

Also if you think i have helped please remember to add a bit of Reputation. Use the * in the Bottom Left of my Posts...

Have a nice Weekend.

Regards

JRidge

Thank you very much for your help