Extracting specific data from multiple workbooks to one masterworkbook by VBA

Hi All,

I am new to VBA, nevertheless I have been through some tutorials. They were mostly about how to extract data from multiple workbooks to one master workbook, but in all of the cases, they took ALL of the data from each workbook.

In my case, I only need some cells from imput workbooks who are all stored in the same folder.

These cells are in every workbook on the same position. In fact, I only want to copy and paste the values of these cells so they fit nicely into one row of the master output workbook always in the same order. So I don't want to extract headers. In this master workbook each row is the data from one input workbook starting from row 2 to endless.

In attachement i have put:
- the output master workbook where: Row 2 is an example of how the data should be and Row 3 shows the source of this data (just for showing you, this will not be necessary in the real masterworkbook)
- one of the input workbooks where the cells are highlighted who have to become extracted


I already started on a VBA code, but I have no idea how to complete it. I tried to extract one value already (for exemple cells BCDE3), but with this code it gives an error. Can someone get me one the right path please?

HTML Code: 

Many thanks,

Thms V

What is

Please Login or Register  to view this content.

?

my guess
If all the worksheet name is common like "Table 1" then

Please Login or Register  to view this content.

Hi Jindon,

With this code I can continue. Thank you.


Thomas