Can you describe the types of data you've captured and any calculations/links you've found worthwhile?
Imagine 2 excel sheets in one document. One has a small currency conversion table linked to the net to stay current. The other sheet has a table of all vendors on the vertical axis and the 12 months along the horizontal axis. At the end of each month I use the number added to my bank to fill in that table. At the bottom of each month there is the simple calculation to add the dollar amounts together. And below that is a conversion to sterling using the currency conversion table to stay current. Meanwhile, the totals of that table are the data source for bar graphs and pie charts. The graphs are updated automatically as each cell is filled in.
My ACX spreadsheets are WAY more complicated. I have 6 sheets plus the currency conversion sheet. A seventh sheet is the results page. Each sheet belongs to 1 book series (that's 4) and 2 spare for series I planned to write but didn't yet. Each sheet has a table for each book. Each table has the name, the month, and the 3 columns for each TYPE of audible sale, the total of sales, and a multiplication of royalty and sales to give a dollar earned amount.
Now do that for every book and audio box (16 and counting) and send the series totals to a table where each book is combined to give series totals. THOSE tables are used in graphs.
If you want to I can send you the excel, but as I said they are linked with previous years. I have no idea how you would find all those broken connections and replace them. I built my sheets slowly over many weeks until I had one working. Then I duplicated it for each series. Then at year end, I duplicate the entire thing, set sales on each sheet back to 0 and change the year part of the links to link to the new "last year" sheet.