title: Populate several cells with values from list based on value of another cell
body: <p>I am looking for some help with a report. On 'sheet1', I have a list of regions, and corresponding hospitals, structured in a format like this:</p>
  
  <pre>   A              B             C             D              E          
  1 Regions     Region 1      Region 2      Region 3       Region 4
  2 Region 1    Hospital 1    Hospital 6    Hospital 11    Hospital 15
  3 Region 2    Hospital 2    Hospital 7    Hospital 12    Hospital 16
  4 Region 3    Hospital 3    Hospital 8    Hospital 13    Hospital 17
  5 Region 4    Hospital 4    Hospital 9    Hospital 14    Hospital 18
  6 Region 5    Hospital 5    Hospital 10
  7 Region 6
  8 Region 7
  9 Region 8
  </pre> 
  
  <p>On my 'report' sheet, I have the following table set up with column headers 'Region' in A6 and 'Hospital' in B6:</p>
  
  <pre>       A              B            C            D            E
  6   Region         Hospital
  7   Region 1       Hospital 1
  8                               
  9
  10
  11                 Hospital 2
  12
  13
  14
  15                 Hospital 3
  16
  17
  18
  19                 Hospital 4
  20
  21
  22
  23                 Hospital 5
  24
  </pre>
  
  <p>What I would like to do:
  Upon selecting 'Region 1' from the list I have in A7 of the 'report' sheet, I would like B7, B11, B15, B19, and B23 to populate with the values listed in the column headed 'Region 1' (Column B) of 'sheet1'.</p>
  
  <p>As an added complexity, I need the solution to be dynamic, in that when I add a hospital to one of the 'region' columns in 'sheet1', this will also be carried over to the next free cell in column B of the 'report' sheet when that region is selected in A7. There are 3 cells between each 'hospital' in the report sheet.</p>