title: Copy and paste items from hidden sheets 2, 3 and 4 into sheet 1 if specific option chosen
body: <p>I am hoping that someone might be able to assist with a vba code that I am trying to apply to my workbook. I have created a dropdown list of 3 options in cell a1 on sheet 1 of my work book.  Ideally, when an option is selected it will automatically pull the cell format, contents, and codes from another work sheet and apply it to sheet 1. So ideally the code would generate the following results:</p>
  
  <pre><code>Text "Option 1" is selected from drop down in a1 - sheet 2 content copy and 
  pastes in sheet 1 starting at cell b1
  Text "Option 2" is selected from drop down in a1 - sheet 3 content copy and 
  pastes in sheet 1 starting at cell b1
  Text "Option 3" is selected from drop down in a1 - sheet 4 content copy and 
  pastes in sheet 1 starting at cell b1
  </code></pre>