phone a friend = spider_poison
This was a roll up sheet from my GCarmies 2009 spreadsheet from last year. Each event (I was playing in) had its own tab and the top 8 armies on each tab autopopulated on this roll up tab.
I use a master SS to house all the units in sortable, filterable fashion that also auto calculates points and hexes as units & quantities are designated. From there, I copy paste the chosen units into the current Army spreadsheet.