I am like you and have pictures on cds and many computers, but I organized them. I still gotta sort through and work on labeling things, but it has made it pretty easy. But I recommend you download
Picasa, it is a free program made by Google. There are some things I wish it would do but you get what you pay for.
It searches every file on your computer and finds every image and organizes it by the file it is under. It has basic editing software, makes a basic slideshow, allows you to reorganize pictures, name them, you can also upload them directly to a website so you can order prints from some of the big photo retailers. You can import pictures from a CD or if the computers are networked together you can get pictures from one to another to organize all of them. It is very helpful as it puts all of your pictures together and allows you to easily view them.