title: Excel VBA: How to create multiple Excel files using a single Excel template
body: <p>My requirement is simple:</p>
  
  <p>I have a list of filename in column <code>A:A200</code> of Sheet1 of Book1 and an Excel Book2 which is a readymade template with 6 sheets.</p>
  
  <p>I need to create or rather replicate this excel Book2, by changing the file name of the template excel to the names I have in column <code>A:A200</code> of sheet1 of Book1.</p>
  
  <p>Also a small functionality would be that the same name (name of the Excel or the name present in the column <code>A</code>) should be added to Sheet1, cell <code>B5</code> of the new sheet.</p>
  
  <p>So basically I have to make copies of an excel template and rename them according to my list and also change a value in the new sheet as the name of the Excel.</p>
  
  <p>Am sure many users would have wanted this simple functionality, so any small VBA code, or reference to any code already present would be helpful.</p>