Drop down list, display certian cells each option

[VaughanCarver]

Morning folks,

Hands up, I'm abit of an excel amateur. Hoping for abit of guidance and assistance.

-I've got a drop down list with 20 options.

-Each time the list of dropped down and 1 of the 20 options are selected I want the cells below to paste a selected cells layout I have created on sheet 3.

Basically, 1) is this even possible 2) how to do it?

I have my list of options on sheet 1, and I have my cell layouts per option on sheet 3.

Any and all thoughts on the matter are welcome.

cheers.