I am not really sure, but it is very rare to find drum sheet music for different songs.....it is just not really done because in a band setting, the drummer very rarely uses sheet music...they may just have a drum chart or something.
If the bands are popular, they may publish drum charts though. I have some drum sheet music from Led Zepplin, but that is because Bonham was such a revolutionary drummer (pretty cutting edge stuff back then)...and so they published some of his stuff.
I have never heard of a program that will right the sheet music from a cd...I don't think that it exists. If you want to learn a beat from a song, then the best thing to do is to pick it out by ear. If you want something that writes sheet music (you write it into the program), something like Cakewalk does this very nicely...and other notation programs help too.
~Milkman