I have Work book 1,2,3,4,5.... 12
in ever work book i got Target, Achievement as Area, Finance etc.
i Have work book named Report.xls
here i got Sum of Area of 12 work book, it percentage to target.
Now i need, whenever i download workbook 1 2 3 4 etc, the report table to be updated...