title: how to concatenate multiple excel sheets from the same file?
body: <p>I have a big excel file that contains many different sheets. All the sheets have the same structure like:</p>
  
  <pre><code>Name
  col1  col2  col3  col4
  1     1     2     4
  4     3     2     1
  </code></pre>
  
  <ul>
  <li>How can I concatenate (vertically) all these sheets in <code>Pandas</code> without having to name each of them manually? If these were files, I could use <code>glob</code> to obtain a list of files in a directory. But here, for excel sheets, I am lost.</li>
  <li>Is there a way to create a variable in the resulting dataframe that identifies the sheet name from which the data comes from?</li>
  </ul>
  
  <p>Thanks!</p>