Excel Script to Aggregate Data and Sort

Excel file that contains several years of data by name, each name could appear more than once in a file. Total all the like names in charts and return a total sorted report. RANK - ARTIST NAME - TOTAL(from files 2010, 2011, 2012) for instance in the sample input: 2010 1 U2 70792 2011 1 U2 60832 2012 1 U2 3424 Output should be a file with a new set of rankings by total in this case it would most likely be 1 U2 135048 2 3 Create macro/script so I can do this for other set of files. Sample file set attached. Would need to run for files with different file names. But same format. ## Deliverables * * *This broadcast message was sent to all bidders on Tuesday Jan 24, 2012 9:37:49 AM: Updated with sample files, and description, please review and update bid. Will accept a bid soon.