title: Excel - How populate a column from another sheet based on unique column header names
body: <p>This cant be difficult but I just can't see how to do it.</p>
  
  <p>I have Sheet 1 with i.e 3 empty columns, the top row is a data validation dropdown list of i.e. 50 unique header names present in Sheet 2.</p>
  
  <p>Under each of the 50 headers in Sheet 2 there is an unknown number of rows of data.</p>
  
  <p>From each of the 3 dropdown menus in Sheet 1, I simply want to populate that column with all data under that column header in Sheet 2. </p>
  
  <p>Is there a VBA solution?</p>