title: Comparing and extracting Rows
body: <p>In my Workbook I have a number of sheets containing customer data. These sheets where extracted from a very large set of Master data and are split based on factors such as the record missing an email address, phone number or a department code.</p>
  
  <p>What I need to guard against is those records that are contained in <strong>multiple sheets</strong>, I need to be-able to confirm that each record only occurs once across the different sheets. Is there a way to compare the Customer Number (the first Column in all the sheets) across the sheets,pinpoint duplicates and automatically remove these leaving one instance of each customer across the workbook?</p>