Trying to build a log book in excel

Hello ,

First off there is a wealth of information in this forum and I am glad I found you all!

Now here is my issue I am using Excel 2011 on a mac and I am building a log for work. Please see the attached log. Page 1, Log has all of the information that we use. Page 2 has all of the Data. I want to be able to select the Specific Company from the drop down in this instance I selected Co.1 and for Program I selected Accident. Now when this information is selected I want it to populate automatically on Page 2 For all instances. I hope I was clear on what it is I am trying to accomplish and I hope it is something that Excel can do. Either way I appreciate any help or advice you can give.

Thank you,

Sgalbo

Steve.