Autofill Colums based on combo box choice

I have attached a rudimentary sheet. I was wondering how I could populate the values from Sheet2, onto the column in Sheet1, based on the combobox choice.

Please Login or Register  to view this content.

When this is applied to the combobox1 change event, it takes the blanks on sheet 1 and writes them to Sheet 2, leaving my data blank. I was looking for reading sheet 2 and displaying the values on Sheet 1. I'm sorry if I was not clear :/

Please Login or Register  to view this content.