Consolidation of tables

Hi,

I have three tables (1, 2, 3), each with three columns (A, B, C), and need to consolidate those into one table 4 with three columns.

Table 1
A: Data
B: Blank
C: Blank

Table 2
A: Sometimes data, if data in B
B: Data
C: Blank


Table 3
A: Blank
B: Sometimes data, if data in C
C: Data


Table 4
A: Data from A in Table 1 and Table 2, sorted in ascending order
B: Data from B in Table 2 and Table 3, sorted in ascending order
C: Data from C in Table 3, sorted in ascending order


Table 1 is really just one column of data (A), but I have added two dummy columns to show how the data fit in with the other tables.
Table 2 is actually two columns of data (A and mainly B), but I have added dummy column C for clarity.
Table 3 is actually two columns of data (B and mainly C), but I have added dummy column A for clarity.


I need a dynamic array formula which can produce the results seen in table 4 of the attached workbook.

If it is possible to have one formula for each of the columns A, B and C of table 4, that would be great. Otherwise, one formula for all three columns is also fine.

It would also be good if the data from table 1, 2 and 3 were brought into the formula as individual columns, since the columns A, B and C in these tables won't necessarily be side by side in real use, and also the dummy columns will not be present.

A key feature of the data is that a single A can point to many Bs which again can point to many Cs (a single C can point to only one B which again can point to only one A).

Regards,
Marbleking