NEED BASIC EXCEL REPORTING SHEET MAYBE VBA / MACRO

HI HERE IS THE PROJECT. MY BOSS HAS +/- 40 SHOPS. THERE ARE +/- 11 MANAGERS. EACH MANAGER MANAGES +/- 2 TO 5 SHOPS. EVERY WEEK MY COLLEAGUE RECEIVES AN EXCEL FILE WHERE THE SHOP MANAGERS REPORT ALL THE ISSUES THE SHOP HAVE HAD DURING THE PAST WEEK. REPORT IS SENT EVERY TUESDAY. THIS REPORT IS ATTACHED (WEEKLY OUT ADMIN [login to view URL]). MY COLLEAGUE NEEDS TO REPORT ALL THESE ISSUES TO THE CEO ([login to view URL]) BUT UNDER THE FORM OF FIGURES. EXAMPLE: SHOP XXX HAS WRITTEN ABOUT 2 ISSUES UNDER THE STAFF TO STAFF ISSUES. MY COLLEAGUE WILL ONLY WRITE THE FIGURE 2 UNDER THE SAME COLUMN AND FACING THE SAME SHOP XXX IN HER REPORT TO THE CEO. THE CEO REPORT NEEDS TO SHOW HIM: THE FIGURES PER KIND OF ISSUE/SHOPS FOR 1 PARTICULAR WEEK AND THE TOTAL BY KIND OF ISSUE/MANAGER FOR 1 PARTICULAR WEEK AND THE TOTAL BY MANAGER FOR 1 PARTICULAR WEEK AND THE TOTAL FOR ALL SHOPS FOR 1 PARTICULAR WEEK AND THE SAME AS ABOVE BUT INSTEAD OF TOTAL FOR 1 WEEK, SIMPLY TOTAL TO-DATE AND ALL THE ABOVE IN EASY TO READ GRAPHS THAT AUTOMATICALLY UPDATE WHEN MY COLLEAGUE ENTERS THE NEW FIGURES IN THE CEO REPORT. IDEALLY: THAT THERE WOULD BE SOME KIND OF "HOOK" BETWEEN THE 2 REPORTS (CEO REPORTS AUTO UPDATE AFTER MY COLLEAGUE FILLS THE FIRST ONE). BUT IF IT IS TOO COMPLICATED (MAYBE BECAUSE MY COLLEAGUE RECEIVES INFO FROM SHOPS UNDER THE FORM OF "STORIES" NOT UNDER THE FORM OF ISSUES...). I HAVE TRIED TO DO SOME WORK. IT IS PARTLY DONE. IT MIGHT BE VERY USEFUL AS IT MIGHT BE COMPLETELY USELESS. YOU WILL FIND THEM ATTACHED. DO NOT HESITATE TO CHANGE ANYTHING NECESSARY. REMEMBER: SHOPS MANAGER SEND THE WEEKLY OUT ADMIN REPORT TO MY COLLEAGUE. MY COLLEAGUE USES THE WEEKLY OUT ADMIN REPORT TO FILL THE CEO WEEKLY OUT ADMIN REPORT. THE CEO NEEDS TO BE ABLE TO SEE EASILY AND AUTOMATICALLY (BUTTONS ETC...) THE REPORTS BY: SHOPS MANAGER WEEK KIND OF ISSUE AND MAKE ALL KIND OF TOTALS AND AUTOMATICALLY MAKE ALL KIND OF GRAPHS IT IS NOT TOO DIFFICULT I KNOW BUT I SIMPLY DON'T HAVE THE TIME ANYMORE. PLEASE DON'T ONLY TELL ME IN PM "I AM THE BEST", GIVE ME YOUR IDEA OF HOW NICE AND SOLID AND PROTECTED YOU CAN MAKE IT. THANKS P.S: I ALSO NEED THE FREELANCER TO TAKE CARE OF THE DATES. THE DATES ARE EASY TO INPUT. IT IS SIMPLY THE DATE OF EVERY TUESDAY OR 2011 (AT LEAST 31/12/2011) AND WHY NOT 2012 THANKS PRIORITY TO SMALL PRICE AND SUPER FAST RESULT...