Combining data from multiple excel files, based on serial number, into summary sheet.

[bambamdan]

Hi there,

I have 5 excel documents, each containing 1 worksheet that lists a set of information relating to a serial number like in the table below. In each of the documents the list of the serial numbers is the same, but the properties are different e.g. Document 1 contains property A, B, C Document 2 contains property D, E, F. etc.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Serial Number[/TD]
[TD]Property A[/TD]
[TD]Property B[/TD]
[TD]Property C[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]4768[/TD]
[TD]123[/TD]
[TD]3[/TD]
[TD]24[/TD]
[/TR]
</tbody>[/TABLE]

What I'm trying to do is combine all the documents into 1 summary worksheet that contains all the data listed against each serial number so it looks something like the second table: In the past I've used VLOOKUP for completing a similar process where all the data is in one document but I don't really know where to start when trying to combine multiple documents, any help would be much appreciated.
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Serial Number[/TD]
[TD]Property A[/TD]
[TD]Property B[/TD]
[TD]Property C[/TD]
[TD]Property D[/TD]
[TD]Property E[/TD]
[TD]Property F[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4768[/TD]
[TD]123[/TD]
[TD]3[/TD]
[TD]24[/TD]
[TD]2[/TD]
[TD]43[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]