title: Combining excel workbook sheet into one using python
body: <p>I have roughly 30 excel workbooks I need to combine into one. Each workbook has a variable number of sheets but the sheet I need to combine from each workbook is called "Output" and the format of the columns in this sheet is consistent. </p>
  
  <p>I need to import the Output sheet from the first file, then append the remaining files and ignore the header row. </p>
  
  <p>I have tried to do this using glob/pandas to no avail. </p>