title: Search (in folders and subfolders ) and read files to a list of dataframes, using Python
body: <p>I have a code</p>
  
  <pre><code>df1 = pd.read_excel('DIRECTORY\\file.xlsm', sheetname='Resume', header=1, usecols='A:I')
  #some operations
  </code></pre>
  
  <pre><code>bf1 =pd.read_excel('DIRECTORY\\file.xlsm', sheetname='Resume', header=1, usecols='K:P')
  #some operations
  </code></pre>
  
  <p><code>Final_file = pd.concat([df1,bf1], ignore_index=True)</code></p>
  
  <p>Note that df and bf are reading the same file, the difference is the columns being read.</p>
  
  <p>I have a lot of files.</p>
  
  <p>Is it possible to go through folders and subfolders, search for a filename pattern and create a list of dataframes to read, instead of writing each path I have?</p>