Combine data of some cells in multiple excel files into one sheet

Hi guys,

I have hundreds of sheets with the same layout and I need to extract data from those sheets into 1 sheet.

There is a very similar topic I found some days ago in this forum, but my case is a bit different, as I need to extract the info only from some cells. The topic is below and Alf solved the problem:
http://www.excelforum.com/excel-prog...worksheet.html

The sheets are all into the following folder: C:\Users\5 - PRODUCTION\RUN SHEETS\
The cells it needs the extract the information are: C3, C5, C8, D8, E8, D9, G13, H13, F22, F24, F26, F29, F31, F34, F40, D43, E43, F46, D49, E49, F52, F55, C58, C59, C60, C61, C62

There is a macro that can extract the info from these cells into a single sheet?
This can save me some months of manually typing all this info :/

You can find below 1 of those hundreds (maybe thousands) sheets I need to extract the info:
2308.E5.xls

Really hope you guys can help me on that!
Thank you!

Hi ricdamiani

In which way want the combine data means rows wise or column wise.

for better understanding please provide one 3,4 workbook combine sample workbook.

Hi Naveed Raza,
Thank you for your reply.

Please find attachments below:
0102.E1.xls
1282.E2.xls
2007.E2.xls
2310.E3.xls
Goal.xlsx

The goal sheet show the sheet I am looking for, with this structure, that compile all the other sheets into this one. The letters+number inside the cells are the cell number I need to extract from the other sheets.
The other sheets I attached, are examples of some of the sheets that I need to extract the information. You can see that the red cells are the cells I want to extract the information.

Do you think it is possible?

I thank you in advance.

Originally Posted by lotuxel

Hi rocdamiani,
Pls see below and you have to put all the files to one file's sheets and Goal sheet is target sheet.

Please Login or Register  to view this content.

Hi lotuxel,
Thank you for your reply.

Sorry but I didn't understand very well.
I thought the macro was going to open each excel file in the folder and copy those cells into the goal sheet.
Is that happening in the macro? Or how it works? I couldn't understand very well your explanation before the code

Looking forward to hear from you

Just a second i think i solved

Hi ricdamiani

Try this..
put all the files in folder and put Goal file separtly and open the goal file and press alt + f8 and run it.