Creating a summary table using formula

I am very new to excel and don know much about formulas. I am struggling to create a small excel sheet as attached. In the main table there wil be many columns. First column will the the patch number. The rest of the columns are for my testing kits and will contain the date on which the patch has been installed on the kit. Next table has the summary of the patchs installed on all the kits. How could I automatically populate the information in the second table ?? Any help on this would be really apreciated.
sample spready attached.

Thank you