title: Is there a way to combine multiple excel-sheets from multiple excel-files with the same format?
body: <p>I have a folder with 100 excel-files which each have 10 different sheets. The format and the name of the sheets are exactly the same for all 100 excel-files.</p>
  <p>Is there a way to make a DataFrame for each sheet containing data from all 100 Excel-files? So for example, there is a sheet called &quot;Population&quot;, and I want to make a dataframe including the population-data from all the 100 excel-files combined.</p>
  <p>Is this possible? I am not a Python-pro, but I have tried many different things. Most guides help you to combine multiple excel-files or multiple sheets within one excel-file.</p>