Dynamic Table based on added item to a 2nd table

[Perryb]

Hello,
I am working in Excel 2010, and would like to find a way to dynamically Expand a table with 10 rows added for each new project added in a 2nd table. So, for example, in the 1st table below, the 1st project from Table 2 is C-1. In table 1, the 3rd and 4th column defines Diciplines and departments for 10 rows, which need to be dynamically added each time a new project is added to Table 2. So, as you can see in Table 2, the last project added is test1. I am looking to dynamically expand Table 1 to add the 10 rows for the test1 project (so there is identical entries in column 3 and 4 for each project)

	Project	Discipline	Department
1	C-1	Hardware	Electrical
2	C-1	Hardware	Mechanical
3	C-1	Hardware	PLD
4	C-1	IPT	PE
5	C-1	Software	Software
6	C-1	Systems	Reliability
7	C-1	Systems	Systems Design
8	C-1	Systems	Test Systems
9	C-1	Lab	Lab Technician
10	C-1	Drafting	Drafting
1	C295	Hardware	Electrical
2	C295	Hardware	PLD
3	C295	IPT	PE
4	C295	Software	Software
5	C295	Systems	Reliability
6	C295	Systems	Systems Design
7	C295	Systems	Test Systems
8	C295	Hardware	Mechanical
9	C295	Lab	Lab Technician
10	C295	Drafting	Drafting
1	C130	Hardware	Electrical
2	C130	Hardware	PLD
3	C130	IPT	PE
4	C130	Lab	Lab Technician
5	C130	Software	Software
6	C130	Systems	Reliability
7	C130	Systems	Systems Design
8	C130	Systems	Test Systems
9	C130	Hardware	Mechanical
10	C130	Drafting	Drafting

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

New Programs

C-1

C295

C130

test1

<colgroup><col></colgroup><tbody>
</tbody>

Thanks
Perry