I created a worbook with multiple pages. I then consolidated the data. I
had to save it under a new worksbook name. In this new worksheet I need to
be able to update the information and have it update the consolidated
information. How is this possible