title: How to conditionally merge/join excel worksheets?
body: <pre><code>+---------+---------+  +---------+--------------+  +---------+-------------+
  + country + widgets +  + country + frammis rods +  + country + comex gears +
  +---------+---------+  +---------+--------------+  +---------+-------------+
  + alpha   +       1 +  + bravo   +            8 +  + charlie +          18 +
  + bravo   +       3 +  + charlie +           16 +  + delta   +           9 +
  + charlie +       7 +  + delta   +           32 +  +---------+-------------+
  + delta   +      11 +  +---------+--------------+
  +---------+---------+
  </code></pre>
  
  <p>I have several Excel worksheets like these ^^^ within the same spreadsheet.  I'm trying to create a new worksheet that contains merged data showing only those countries with data in <strong>all</strong> the worksheet categories.</p>
  
  <p><strong>E.g.,</strong></p>
  
  <pre><code>+---------+---------+--------------+-------------+
  + country + widgets + frammis rods + comex gears +
  +---------+---------+--------------+-------------+
  + charlie +       7 +           16 +          18 +
  + delta   +      11 +           32 +           9 +
  +---------+---------+--------------+-------------+
  </code></pre>
  
  <p>I'm looking for a fairly simple, flexible way of doing this as the various worksheets are updated / new worksheets are added.  I know how to do this in MYSQL, but I'm not sure if its possible in excel.  </p>
  
  <p>So, what do the experts have to say?</p>
  
  <p>Thx in advance. :)</p>