I have a file with a large number of tabs--about 80--that sum to a lead
sheet. I want to be able to view, by tab, the values in a given cell from the
lead sheet. So for instance, in cell C30 on the lead sheet I should be able
to get a subview of all the numbers in the various tabs rolling into that
cell (with the tab identified). Otherwise, I must go tab by tab to verify
each value, a time consuming process when you have hundreds of cells that
must be checked over 80 tabs. Thanks.