"The application Pages quit unexpectedly. Mac OS and other applications are not affected." Then I have the option to relaunch (doesn't work), report (I did) or relaunch (didn't work).
Well that's some useful information not previously available.
Open up your username/Library/Preferences folder and move com.apple.pages.plist to your desktop.
Now try to open Pages again.
Pages is no longer listed in my applications.
Ok, gotta ask again as your terminology is not very clear. Do you mean the main Applications folder or your own user Applications folder, or something completely different? The main folder is where it should be, and it is located in your hard disk/Applications.
Now, previously you said that you get an error message that it quit unexpectedly, which differs from this post saying you don't have Pages.
Since you upgraded to Leopard, it may be possible that you no longer have Pages on your hard drive, depending on how you upgraded. If you chose "Upgrade" or "Archive and Install," then you should still have all your documents and Applications. If you chose Erase and install, then you won't have pages and will have to re-install it from your original copy. If it came installed on your computer, they it will be on the original install disks.