I have a spreadsheet document with multiple sheets. Every business day I duplicate the previous day’s sheet and change values in some of the cells based on external data, stock prices to be exact. Every month I start over by making a new document for that month, then a new sheet for each day, so each document I make will eventually have about 20 sheets in it, one for each business day of the month. Each sheet performs certain operations on some of the values and calculates a number that appears in a specific cell, H4. So, every day, the new sheet has a new value in H4.
Is there a way to make one chart on one page of each document that will chart the values in H4 from each sheet in the document?