title: How to reference files, each in a different folder?
body: <p>I have 100 Excel files, and each file is located on diffrent folder in the drive.</p>
  
  <p>For eg.</p>
  
  <pre><code>file 1 = C:\DATA_DIR\TEST_1\2018_11_26.0001\Excel.xlsx  
  file 2 = C:\DATA_DIR\TEST_1\2018_11_26.0002\Excel.xlsx 
  file 3 = C:\DATA_DIR\TEST_1\2018_11_26.0003\Excel.xlsx
  .
  .
  .
  file 100 = C:\DATA_DIR\TEST_1\2018_11_26.0100\Excel.xlsx
  </code></pre>
  
  <p>In each Excel file, the data is located at <code>cell (1,1)</code>.</p>
  
  <p>I want to take the data from every Excel file and save it in one Excel file in one column.</p>
  
  <p>The code I have, was good enough for small amount of data, </p>
  
  <pre><code>a=xlsread('K:\Repeatability\C1X\2018-11-07.0001\Radial_Accuracy.xlsx'); 
  
  b=xlsread('K:\Repeatability\C1X\2018-11-07.0002\Radial_Accuracy.xlsx'); 
  
  N=[a(1:1,:) ; b(1:1,:)] 
  xlswrite('K:\Repeatability_Test\New.xlsx',N);
  </code></pre>
  
  <p>In this case and in future, I'll have a bigger amount of data. I don't want to specify each folder location.</p>