title: VBA recognizing workbook by partial name
body: <p>Is there a way to specify a workbook for a sheet without having the full name?
  For example, If the workbook name is MyWorbook2015 and the 2015 may change to 2016 in the future, I need to to recognize the workbook based on MyWorkbook, and ignore the 2015.  Something similar to this:</p>
  
  <pre><code>With Workbooks("MyWorkbook2015").Sheets("My_Sheet_Name_That_Does_Not_Change")
       'do something
  End With
  </code></pre>
  
  <p>In the code sample above, I need it to recognize the work book regardless of the date?  Is this possible? If it is, how would I go about doing that?</p>