title: How do I dynamically update the name of a worksheet in Excel?
body: <p>I have an Excel spreadsheet which is being used to specify filesystem build information for our Unix team.</p>
  
  <p>This worksheet would have different information depending on the system to be built.  For example, a production system would have many filesystems, whereas a development system only one or two.</p>
  
  <p>So based on user input, we would populate one or other of the two input worksheet formats ("dev","prod") but the destination worksheet will be always be the same.  Only one of the dev or prod worksheets would be visible and active for users to input data at any given time.</p>
  
  <p>How do we tell Excel to use a particular input worksheet to calculate another output worksheet?</p>
  
  <p>My initial idea was that, for simplicity's sake, the "output" worksheet would take its data from an "input" worksheet, and that we would dynamically make either the "dev" or "prod" template become the "input" worksheet.  Is this the right way to do this, or is there some better method?</p>