AutoFill Cell w/ data from different sheet after action

I have an excel file that contains two sheets. Sheet2 contains rows of different types of products with each of the columns containing details about the product.

On Sheet1, I have setup a data validation list in which a certain cell contains a drop down box that selects a product from the first column of all the rows on t from Sheet2. I used

=INDIRECT("Sheet2!$A$2:A$1000")

When a list item is selected, I would like a function to be ran in which it autofills the columns to the right on this Sheet1 with the data from Sheet2 of the detailed information. I believe this can be done with vlookup but am having some difficulties with it returning N/A no matter what I choose.

Thanks