title: Function or code to compare multiple sheets in Excel and display them sorted in ascending order in a new sheet
body: <p>I have a workbook which has let's say 3 similar worksheets. Each from different supplier. I want to compare them to find out who is cheaper and who is the cheapest with each and every item. 
  For example:</p>
  
  <p>Worksheet 1 (D) (stands for David)</p>
  
  <pre><code>    A            B             C             D
      1            quality 1     quality 2     quality 3    .....
      2 Apple      20            30            40
      3 Orange     25            33            46
  </code></pre>
  
  <p>Worksheet 2 (O) (stands for Oliver)</p>
  
  <pre><code>    A            B             C             D
      1            quality 1     quality 2     quality 3    .....
      2 Apple      18            30            35
      3 Orange     25            35            46
  </code></pre>
  
  <p>Worksheet 3 (H) (stands for Harry)</p>
  
  <pre><code>    A            B             C             D
      1            quality 1     quality 2     quality 3    .....
      2 Apple      22            33            44
      3 Orange     20            36            39
  </code></pre>
  
  <p>I expect the output to be something like this:</p>
  
  <p>Worksheet 4 (sorted by the cheapest)</p>
  
  <pre><code>    A            B             C             D
      1            quality 1     quality 2     quality 3    .....
      2 Apple      O;D;H         D=O;H         O;D;H
      3 Orange     H;D=O         D;O;H         H;D=O
  </code></pre>
  
  <p>Thanks in advance for your time and consideration.</p>