Hey! Sorry to hear about your husbands favourite Kansas CD getting wrecked. As far as I know, they haven't released any compilations that include their entire discography and so if you want their complete works, I think you'd just have to order all their albums. I'm not sure where the best place to get them would be, but I guess you might be able to find some reasonable prices at
Amazon.com.
If you get more CDs, there is of course a danger that they too get wrecked. Have you thought about getting a digital music collection and play your music from a computer?
edit :
By the way! For a list of their discography, just check out
wikipedia 