title: Use a excel cell reference to indicate tab name inside a formula?
body: <p><a href="https://i.stack.imgur.com/5k30V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5k30V.png" alt="Example"></a></p>
  
  <p>I have a document that has 52 tabs, one for each week. They're named 
  <code>Week (1), ...,Week (52)</code>. In the 53rd tab, I have a summary of the data inputted into every tab.</p>
  
  <p>The idea is that my supervisor copies and pastes data per week, hiding the tab as she completes that week, and the 53rd summary page will show the entire year broken down per week.</p>
  
  <p>My problem is, the formula for one of the cells is <code>=SUMIF('Week (1)'!$B:$B,B3,'Week (1)'!$G:$G)</code> where the point is to add up the column G in Week (1) for each entry where B3 equals the corresponding cell in Week (1) column B on the same row.</p>
  
  <p>Since I have this copied 52 times, I would ordinarily have to manually enter each tab into the various different formulas, replacing Week (1) with Week (2), etc and so forth until Week (52).</p>
  
  <p>Is there a way to instead have the following formula:</p>
  
  <p><code>=SUMIF('[REFERENCE TO CELL CONTAINING TAB NAME]'!$B:$B,B3,'[REFERENCE]'!$G:$G)</code></p>