title: Rename worksheet based on cell value
body: <p>I have three worksheets in excel which I am using. </p>
  
  <p>First page is where I put all the data so it can populate in sheet 2 and sheet 3. </p>
  
  <p>Sheet 2 and 3 is what I am going to save as pdf. </p>
  
  <p>My question, is there a vba code that will name sheet 2 with the value in cell <code>A1</code> with the letter "F" next to it and then page three with the cell value in A1 again but with the letter E next to it? </p>
  
  <p>For e.g. cell <code>A1</code> has Joy Nice, worksheet 2 will be named Joy Nice-F and worksheet 3 will be named Joy Nice-E. And yes I am new to VBA and I love what it can do. Thank you.</p>