Auto updating a table

[phil2006]

If I have the following table (sheet1):
A 1 2 3 4 5
B 4 5 6 7 8
C 1 9 0 3 7

...and then (sheet2)

A 1
B 1
A 2
C 6
B 2
A 3
...is there a macro or programme I could run which would insert the values from sheet 2 in order into the rows on sheet one to give:
A 1 2 3 1 2 3 4 5
B 1 2 4 5 6 7 8
C 6 1 9 0 3 7


Thanks very much!

[Herbert Seidenberg]

You might record part of this into a macro to make it "Auto".
Pivot Table > Multiple Consolidation Ranges
Range: Select the data on sheet2; include top blank headers.
Layout: Drag Column button from Column field and
drag in Value button instead.
Data field: Count of Value
Options: No grand totals
Part of he Pivot Table will then look like this:
1 2 3 6
A 1 1 1
B 1 1
C 1

Name the Count of Value matrix <array1>
Name the Column field <vect1>
Create another matrix with this array formula:
=IF(array1>0,vect1,"")
Copy > Paste Special > Value
The matrix will then look like this:
1 2 3
1 2
6
Insert this matrix in the proper place on sheet1.
Remove the blank spaces and left justify with
Goto > Special > Constants > Text
Delete > Shift Left