title: Reference next or previous sheet in a formula if the sheet number/name is a varible/variant
body: <p>How do I reference next or previous sheet in a formula if the sheet number/name is a varible/variant.</p>
  
  <p>I have seen ways to do this with vba, is there a way to do this with a formula or function</p>