Excel 2007 Macro To Aggregate Multiple Worksheet Totals
Hoping someone can assist in developing a macro that will look at multiple worksheets and aggregate column data into a Summary worksheet. Sample attached. Please note that the order the evaluator names are in can differ from worksheet to worksheet and there might be a name on one that does not appear in the others. I've included 3 individual worksheets and a summary page but in the real report will have about 24 worksheets that need to be aggregated so hoping that it will be easy for me to go into the code and add the additional worksheets.