title: excel VBA how to determine sheet index from sheet name
body: <p>In the ongoing project of mine, with which I'm about to be done, I want to make sure that the people taking over my job will be left with something that won't break after I'm gone. This project is an ongoing tracker kept daily throughout the year and each worksheet used (several for varying items of interest) are separated out by year in the name of the worksheet. For instance, the primary sheet is simply called 'YYYY' in which the 'YYYY' is the current year. Other worksheets are called, 'DTDYYYY', 'MTDYYYY', 'YTDYYYY' in which the YYYY is the current year. Come 2013, I'd like it if the little VBA that I use is able to take the current YYYY and find the appropriate worksheets automagically. </p>
  
  <p>I know that I can reference sheets using the SheetIDX convention. I know that I can use Sheets(NAME) method. I'm not so sure how to best go about accomplishing my goal, though.</p>