Excel 2007 : Connecting two sheet and auto update the data

I am working on the excel sheet. In which I have 2 sheets in which one is for engineering scope (which has three levels Black, Blue and Yellow) and other one is for CTR. Now I wanted to make a link or macro whichever is easy. That will select the data for level yellow from the pull down menu and it will also update in the CTR sheet with respective job selected in Engineering scope sheet. Now here I want to have flexibility of adding the line for adding new jobs to the Engineering scope and which will be adding the selection in the CTR file.
In the picture one I will be selecting the “Design Specification” and I wanted that It will be automaticaly update into the second picture in the 2nd spot. If I add a one more row in sheet 1 and select some field and that will also update in that CTR file on the 3rd spot.