Populating information from a different sheet based on option you pick in drop down menu

Hello All,

I am trying to figure out how to populate information from a different sheet in the workbook when you choose an option from a drop down list.

For instance, I want to be able to choose a project from the drop down menu (Air Flare Package MAVP-0310 x 20') automatically insert Sheet 4 below the main page information. Please help.

Hi Shellyshep27

Welcome to the forum

I have produced what I think you want

Please note:

VBA is used - you may have to set your permissions to allow this
Sheet 2 Column B needs to have the exact name of the sheet containing the project. Apostrophes (') not allowed, max length 30
To run the macro use Ctrl+Shift+Q
To see the code use Alt+F8 / Step into

Let me know if this works for you

Regards
Alastair