title: Combine data from two columns into one in excel from different sheets in excel
body: <p>So I have two sheets that are set to pull job orders from an external source.  Sheet one will pull Job Order Type A and sheet two pulls Job Order Type B. These sheets will change when refreshed to reflect current active job orders. Both sheets have different amount of columns and headings and I want to create a third sheet to filter and show both Type A and B.   Column A in both sheets has a job order number, how can I extract this column A in both sheets to create a "Master" list of both type A and B. </p>
  
  <p><a href="https://i.stack.imgur.com/dfeN4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dfeN4.png" alt="enter image description here"></a></p>
  
  <p>I am dealing with a varying number of job orders on each type.  One week could have 300 of type A and then two weeks later it could be 3000.  So dealing with a  large amount of data</p>