title: Dynamic sheet name in Excel
body: <p>I can reference a sheet name from another sheet</p>
  
  <pre><code>='Sheet1'!A1
  </code></pre>
  
  <p>How can I do thus with formula (not VBA or Python, sadly) to find out the name of the sheet dynamically (ie without knowing the name sheet)? Just to be clear I'm after the sheet names/ tab names at the bottom of the window, not the worksheet name</p>
  
  <p>I've got number of spread sheets with a number of sheets (all named differently) and I was looking for a formula that will work with all. One size fits all , if you will.</p>