title: Using A Cell To Reference The Name Of Sheet In A Formula For Google Sheets
body: <p>is it possible to place the name of the first worksheet in a cell and then use it in a formula to reference information for my second sheet?</p>
  
  <p>I am using Google Spreadsheets, and I have one worksheet that houses scheduling data for employees in columns for each day of the week. The second worksheet builds a payroll report, and directly references columns in the first sheet like so: </p>
  
  <pre><code>='Sales Report - WB 10.06'!B3
  </code></pre>
  
  <p>My question is, is it possible to place the name of the first worksheet in a cell ('Sales Report - WB 10.06') and then use it in a formula to reference information for my second sheet?</p>
  
  <p>My current issue is that I have to create a new schedule and a new payroll sheet for 10 different regions on a weekly basis, and duplicating and changing the formulas in 70 columns to reference the correct sheet will become very tedious. </p>
  
  <p>It would be much easier to just update a cell in the spreadsheet so that the formulas point to the correct worksheet to reference data from.</p>