formula to consolidate tables

Hi - I need desperate help!
I have a table (Table 1) with unique index numbers in Column A and names in Column B. For example:
A16 John
R6O Sally
69U Henry
I have a separate table (Table 2), with same index numbers repeating in column A from (also appearing in column A from Table 1) but different names. For example:
A16 Roger
A16 Paul
A16 Owen
R60 Frank
R60 Linda
69U Howard
69U Diana

My objective is to have Table 1 with all names on same row corresponding to the index number in column A and names consolidated from column B, C, D E until no more names appear for that index number. For example:
A16 John Roger Paul Owen
R60 Sally Frank Linda
69U Henry Howard Diana

Is there a formula I can easily use that will do this for me?

Hi Richard. Thanks for the prompt reply.
I was perhaps over-simplified in my request. Enclosed is an example of Table 1 with the source, Table 2 with the added info and Table 3 with the desired results.
You will note that table 2 hasn't got the codes in any logical order. Table 3 has a test area where I highlighted in yellow what I require.
I made an effort in able 3 (range B6:C9) but need the rest populated - Help!!
I am no good with Pivot tables and would prefer a formula. If VBA is easier, then I am happy to take any advice and sample VBA code.
Thanks again,

Thanks again, Richard.
The intention/objective is to have a consolidated table that we can use for Mail-Merge purposes; therefore, I don't believe a Pivot Table is appropriate. The "output" has to be exactly in the format defined in the enclosed "Desired Result" worksheet. Bear in mind, Sheet1 and Sheet2 (samples enclosed) are in fact very lengthy and extensive (further details for each candidate is available). For purposes of this exercise, however, I've re-created a similar set of tables (enclosed) in a cut-down version. Once I have a grip of the formula needed, I can work out the rest (I hope). From the enclosed workbook, you can see in Sheet3 (highlighted in yellow) my failed attempt, as it is not using the right data when using INDEX, so I know I am not doing this right and need expert guidance, if possible.
In effect, the common index identifier is always unique(the code in columns A) on both Sheet1 and Sheet2. I am trying to come up with a table (Sheet3) that has all the details lined-up in a single row (repeating pattern) for each of the codes found I column A. Therefore, VLOOKUP worked to a certain extend, but this is where I got stuck (brain-blocked). Hope you (or someone) can advice best way forward. I hate to copy & paste loads of cells - too laborious and pen to errors. Can you help?

Ah, you've come through for me! Million thanks, Richard.