title: Is there a way to combine all data from similarly-formatted Excel tabs into a separate tab in the same Workbook and be able to synchronize edits?
body: <p>I'm responsible for updating various aspects of data that's currently compiled into similarly-formatted Excel tabs in a workbook. Frustratingly, there are cases where I need to update the same piece of data across numerous tabs, and, though the columns across the tabs are arranged the same way, the sorting and total rows can vary from one tab to the next. If all of the data from all of the tabs was in one large sheet, these edits would be easy, because I could sort and update everything at once depending on what aspect of the information I'm updating.</p>
  <p>Unfortunately, the workbook as it's currently arranged is depended on by many others. I'm not at liberty to combine all the tabs into one sheet and tell all involved to use that.</p>
  <p><strong>What I'm asking: Is there a solution wherein I could &quot;reference&quot; all the data in all the tabs in one large sheet, and when I do an edit to a cell on the large sheet, have the value I type in propagate &quot;backwards&quot; into the referenced location on its original tab?</strong> I am open to obscure suggestions. My time spent navigating between tabs to do mass updates is excessive. It hurts to know my time is being used so inefficiently!</p>
  <p>Thanks to all for any insight. Please also feel free to critique my question itself as I don't believe I've ever posted one on here before.</p>