I'm creating a comprehensive administrative data sheet for the personnel in my office. It's going to include:
1. A contact roster
2. Upcoming Events
3. A Vacation Tracker
4. A task tracker
5. And another different task tracker
I figure I can either arrange each on a different sheet (not preferred), or I can put it all on one sheet. Having everything consolidated on one sheet would be lovely IF it were all viewable in a neat little 1-page configuration (take the "Event Planner" template as an example). If, however, the individual tables have to be viewed as wholes, then it's a whole lot of scrolling that I don't want my users to have to deal with.
I should mention that this is going to be a publicly viewable and dynamically updated document that isn't intended to ever be printed.
Given your comments, it doesn't sound like I can do what I want to do, and that's making me a little sad.
Thanks for your comments, and if my elaboration helped to key you in on something that IS possible, please enlighten me.
Nick