Creating a sheet hierarchy isn't that bad once you get the just of it the video above explains it well. It's mostly linking data to cells outside your current page or book that will allow you to update info on one page and then insert that info into a graph on another automatically. I don't know if this is what you mean by automated.