the problem of formulas in excel, how to find and fill

I have a table this issue, Table 1, there are many tables, but the number of the same cell in Table 1 (1) as follows:ABC D1 123 ASDF 1DE1 2E2D2 D1D 1D1D 1DE1E 1E1E3 123DA 12D1D 1D1D 1D1D4 1231D 1D1D 1D1D 1D1D5 1D1D1 1D1D 1D1D 1D1D Table 1, there are many tables, but the number of the same cell in Table 1 (2) as follows:ABC D1 123 ASDF 1DE1 2E2D2 D1D 1D1D 1DE1E 1E1E3 123DA 12D1D 1D1D 1D1D4 1231D 1D1D 1D1D 1D1D5 1D1D1 1D1D 1D1D 1D1D Table 1 have a number of table, but the same number of cells in Table 1 (3) are as follows:ABC D1 123 ASDF 1DE1 2E2D2 D1D 1D1D 1DE1E 1E1E3 123DA 12D1D 1D1D 1D1D4 1231D 1D1D 1D1D 1D1D5 1D1D1 1D1D 1D1D 1D1D I want to be a matrix, ABCD 1 = Table 1 ( 1) A3 = Table 1 (1) B4 = Table 1 (1) C4 = Table 1 (1) A52 = Table 1 (2) A3 = Table 1 (2) B4 = Table 1 (2) C4 = Table 1 (2 ) A53 = Table 1 (3) A3 = Table 1 (3) B4 = Table 1 (3) C4 = Table 1 (3) A5 to ask what I want to summary table using this simple formula to write it?

This table is not to calculate, but should be summary, according to public works in writing as filled look like!

I tried a bit with the combined operation as not, can not help you sorry.But I would also like to know how.Want you to want to show the results of writing about that a little can not understand, such as adding D1D three times to show the results after the 3D1D or D3D? did not understand the specific requirements.is understood:It is recommended to use together.

you always say or add to it? or what?

do not understand specific requirements.on the understanding that:It is recommended to use together.

I tried a bit with the combined operation as not, can not help you sorry.But I would also like to know how.want you to want to show the results of writing about the that little can not understand, such as D1D after adding the three results to display 3D1D or D3D?