Information page

I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the correct place/format. I know how to do this with Excel but what tool would I use in Smartsheet?

A form is for filling out information to add to a sheet, a report is a summary of a sheet, and a dashboard (to my knowledge) doesn't have the capabilities that I am looking for.