SharePoint is a great way to create dynamic content that can be asily updated. However, on first glance it looks like everything in a site for example, either has to be added to the homepage of that site, or linked to (such as documents, announcements, etc.).
The way round this is to use Web Part Pages. Web Part pages are probably quite under-used in most SharePoint implementations. However, they allow for the capability to create multi-page sites within SharePoint. The reason why they aren't used is that it may not be as intuitive as it could be in how these pages can be used. For example, by default, you can't get these pages listed in the left hand navigation menu where you probably do indeed want them (I'll have to check, but would be surprised if this hasn't been changed in SharePoint 2007).
My suggestion is you create a dedicated "Document Library" for these pages, and call it something like "Site Pages". When creating the document library, make sure the default document template type is set to "Web Part Page" (see image below).

You then create pages by going to the "Site Pages" document library, and click "New Document". It should then prompt you enter a name for this Web Part Page, and the layout.

Once the page has been created, you can drag web parts onto this page, pretty much the same as you can on the homepage of your site for example.

So, now you can see how to create multiple pages for your SharePoint site. However, at the moment these pages aren't easily found within your site (you'll note above I allowed the "Site Pages" to be listed in the left navigation), however, what we really want to do is have each of the pages easily reachable from the homepage of our SharePoint site.
To do this, go to the SharePoint site homepage, and browse the available web parts.

In the gallery, you should now see that "Site Pages" is available in our list of web parts that we can add to the page.

You can now drag this web part onto your SharePoint homepage, to allow quick navigation to your multiple page SharePoint site.

NB I have edited the current view and removed the "Modified By" field. You could carry out further customization using FrontPage 2003 to get the exact look and feel that you desire.
