I have a drop down box in cell J5 that contains a list of VEH-#'s. What I would like is to be able to do is pick one of the VEH-#'s from the list and cells L5, J6, J7, and J8 will be automatically filled in with the correct data that is on another tab.

Example; If I pick VEH-001 from the drop down box in cell J5 then the following will happen:
Cell L5 will show the SAP # for that VEH-#
Cell J6 will show the Make for that VEH-#
Cell J7 will show the Model for that VEH-#
Cell J8 will show the S/N for that VEH-#

Is this possible and if it is how do I set it up?