[NoOne]

if familiar with excel, you can make a output worksheet and use links to the exported files as data worksheets.

type all formulas in the output worksheet by referencing cells from the data worksheet -- either type them or go click on them etc (useful to know syntax).

Now, once you have everythign either simply "=worksheet3.a1" etc to be visible or some advanced stat each and every time you update those external links to the exported files, everythign is updated.

even withoutknowledge, it's simply point-and-click on the cells involved. you only have to setup the first row. *if 2 subleagues, you'll want to also highlight the second row before "filling" as explained below.

to add years, you simply highlight the row and then "fill" down (mouse-over bottom-right of selection until cursor turns to "+" like symbol, then click and drag down in this case). must match orientation of the data worksheets. years ascendending. can sort anyway you want after that point, but keep a "cnt" column to reverse and change, so you can add years easily in future. type "1" in first row and "fill" down.. .it will count up for you.

a cumulative total row can be kept at the bottom.. simply insert entire rows within the table above that row and re-fill down to bottom row. all fixed. either expand on-demand or make a huge table and let it fill up. want to start at a different year? drag that row to the top and re-fill... start earlier? drag the top row down that many years and fill up to top. re-fill down to bottom, if necessary.

the best use of a spreadsheet invovled setting it up 1 time... then using it without as little effort as possible.

i googled a macro that could add a button to the toolbars which updates external links to all files. definitely useful too.

You make the basic shell, and the data will simply accrue. make charts and graphs etc... they will auto-update with the table you create (whether you make grid around it or not, it's a "table" to a spreadsheet program)