I have an excel file with many sheets. At the end of the sheets I’ve created a “dashboard” with summary statistics across these multiple sheets. I would like to have a line chart on this “dashboard” sheet that plots the number in one cell across these many sheets so I can see the trend of this number across sheets. There are two many sheets to add each one to a graph so I’d ideally like to plot something like (‘START:END’!B31). Can I do this and how??
Thanks so much! I have searched and haven’t been able to come up with an answer!