We have a set of Excel spreadsheets which are a list of values against
companies. From these we want to create a master spreadsheet which has all
the company names in alphabetical order in a column with the values from each
list in a separate column.

E.g.
Spreadsheet 1
Name, value1
A 1
B 4
C 4
E 2
F 1

Spreadsheet 2
Name, Value2
B 2
D 3
E 3
G 1
€¦€¦€¦€¦..

Spreadsheet N
Name, Value2
A 1
C 4
H 7

Master Spreadsheet
Name, Value1, Value2 €¦€¦. Value N
A 1 0 €¦€¦. 1
B 4 2 €¦€¦. 0
C 4 0 €¦€¦. 4
D 0 3 €¦€¦. 0
E 2 3 €¦€¦. 0
F 1 0 €¦€¦. 0
G 0 1 €¦€¦. 0
H 0 0 €¦€¦. 7