How to put similar data in several files into a master file without opening source files

Dear developpers,
I am @user level on Excel. But I wish to improve my knowledge. Anyway here is my problem that I couldn't solve:
In a common folder I have around 100 excel files, files' names may vary but inside them data formats are identical. My aim is to take specific datas from these files (ex. from 'bilgiler 2' sheet where datas in F8 & F10) and to join them in single synthesis file (MIMAR.xlsx) automatically:
-To write first 7 letters of file names (as 1204/17,1206/17,1207/17..) in A column in face to corresponding datas (ex. starting in row A48).
- To write data on F8 in starting from row (ex. H48)
- To write data on F10 in starting from row (ex. I48)

These 100 input files increasing every day, thus I should be able to update my master file each time I run the macro.

Can you help ?

Attached I also put exemple files to help for your analize.
Best regards!

Merhaba mehmetcik,
Thanks for your quick reply !
However i couldn't manage it
I created macro1 in Mimar.xlsm and copied the macro you gave. As I runned, first error was: 'Compile error: expected End Sub'. That was a simple one so I added End Sub at the end of macro. Then runned again and error was: 'Compile Error: For without next'.
Maybe some lines are missing in your post..?

Hi muhendisOE,
try this

Please Login or Register  to view this content.

Hi nilem,
It is really great work thank you very much!!
Unfortunately as I ran on original files I just discovered that some of old files do not have exactly the same format, I mean datas to take are not in the same cell as others. Therefore I would need an additional code to findout correct cell having this information. what I observed is that in all files:
sheet name is same (ex. bilgiler 2), but cell is different available in 5 different places possible, I attached 2 options ex exemple.
So something in priority order like:
If a value between 0.3-2.0 is in F275&F277 take them, else check G275&G277, else check H275&H277, else check F160&F162, else check G160&G162.
if you make just first 3 conditions i think I can add the rest.