combining multiple sheets with VBA

[Kellens]

Hello,

I'm having a problem with a Workbook containing 12 or so sheets with some 56 columns per sheet.
I would like to combine all sheets in to one master file and have the data for identical columns combined.
To make it easier i think it is a good idea to start with a sheet that contains all possible column headers and also the supplier ID's

The first sheet then looks as follows with all blanks except first row and first column.

Supplier ID	Feature 1	Feature 2	Feature 3	Feature 4
001
002
003
004
005
006
007
008
009

<tbody>
</tbody>

My second sheet then looks a bit as follows:

Supplier ID	Feature 3	Feature 1	Feature 5	Feature 12
001	152
002		slow
003			846541
004		fast
005	12			strong
006				weak
007
008		intermediate
009
010	09		5674654

<tbody>
</tbody>

So the first column is the same for every sheet.
If i have a column in the second or third (and so on) sheet that is identical to the first sheet i want the data to be included (not added on the bottom but on the same line as the corresponding supplier ID that is present in all sheets).

I hope it is clear what i would like to accomplish. I've tried to do this with the consolidate function wut that won't work.
Can anyone please herlp me out with a VBA script to do this?

Thanks in advance

 

[Kellens]

I hope i can get a solution before my weekend starts