Good Morning,

I need to be able to choose an item from a drop down and have cells fill in. Here is what I have.....
On Sheet 1
Example 1.jpg

On Sheet 2 (the one that needs to fill in depending on what is chosen in a drop down)
Example 2.jpg

For example: I need to be able to choose "ZTSCT MSTD" from a drop down menu and have Sheet 2 fill in to look like this.
Example 3.jpg

Does anyone have an idea how to make that happen? This would save so much time at work I would be a hero.
Thank you in advance to anyone who tries to help.
I hope you all have a wonderful day!