I have 5 child pages for different departments working under the same project. Each page has a table macro with a pie chart set up to track completion of the lines in the tables. I am looking for a way to pull the data from all 5 charts and have another pie chart on the Main Page (Home page) for a quick view of OVERALL completion as a company?
Is there a way to set that up to where as a department child page is updated, the home page is automatically sent that update as well?