title: Python: Loop through a folder and save data from first tab of each file and save to new file on separate tabs
body: <p>I am trying to loop through 8 files in a specific folder and grab the data from specific column in the first tab of each. Then, I want to paste the data into a new, consolidated file with each of the data frames on their own separate tab. This is what I have so far...</p>
  <p>My questions:</p>
  <ol>
  <li>How do I grab the data from the first tab of each file?</li>
  <li>How do I then paste that data into each of their own tabs on a consolidated file?</li>
  </ol>
  <pre><code>import pandas as pd
  import os
  import glob
  
  
  
  os.chdir(file path)
  FileList = glob.glob('*.xlsx')
  
  data = {}
  
  for file in FileList:
     df = pd.read_excel(file, 0, header=9)
     df = df[['Project Code', 'Project', 'Location', 'Opening Balance Dollars', 'Accrued This Year Dollars',
              'Opening Balance + Accrued Dollars', 'Taken Dollars', 'Closing Dollars']]
     data[file] = df
  </code></pre>