title: Combine multiple workbooks each with one sheet into one workbook with multiple sheets
body: <p>I'm new to VBA and I am trying to do the following:</p>
  <ol>
  <li>I have multiple CSV files, each with one worksheet and the workbooks are saved under a specific name.</li>
  <li>The format  of all the workbooks are the same.</li>
  </ol>
  <p>I would like to write a VBA code which would do the following in a separate workbook called RDI raw data.xlsm</p>
  <ul>
  <li><p>In RDI raw data</p>
  </li>
  <li><p>Copy all data from the workbooks into the RDI raw data file but each workbook needs to be a separate sheet in the RDI raw data file</p>
  </li>
  </ul>
  <p>Could someone please help with this?</p>