title: Change variable from multiple sheets?
body: <p>I have an excel workbook with multiple sheets that aggregate costs and revenues of different technological components (set up in different sheets) in a system. </p>
  
  <p>I want to have a main worksheet, where users can change a small selection of important variables from the technology sheets. I also want those important variables to be defined and editable on the technology sheets.</p>
  
  <p>I've been using named ranges to manage variables, but I'm not sure how to link two cells on different sheets to one variable. For example, I want to name a variable "oilprice" that is referenced in different formulas. I want to be able to change the variable "oilprice" from the main worksheet and the electricity technology sheet in my workbook.</p>
  
  <p>Similarly, I want to be able to check a box on both sheets for "Turn on Electricity" and have the checkbox on the other sheet change as well.</p>
  
  <p>I've been looking around on google and stackoverflow but can't find an answer. Thanks!</p>