title: How to create multiple sheets from a list of names which are the selected cells' content
body: <p>Actually, I only need to help to provide some lessons on Excel VBA not for the code.</p>
  
  <p><strong>Problem</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/B8SpE.jpg" alt="enter image description here"></p>
  
  <p>The main line of code is very basic and although I have no experience in VBA, I understand it</p>
  
  <pre><code>Sheets.Add().Name = Name_of_Sheet
  </code></pre>
  
  <p>If I define a list of name like <code>NameList =Array("SheetA", "SheetB", "SheetC","SheetD")</code> then do the for loop</p>
  
  <pre><code> For I = LBound(NameList) To UBound(NameList) 
      Sheets.Add().Name = Tabs(I) 
   Next I 
  </code></pre>
  
  <p>However, many times, there are standard for naming the sheets, going to Visual Basic to edit the macro is not very efficient.  I would like to just create the sheet from the cells' content</p>
  
  <p><strong>My questions</strong>:</p>
  
  <p>1) How does the index of selected data (1D columns, 1D row, or multiple rows x multiple columns) work? </p>
  
  <p>2) How can I access these cells' content?</p>