A wonderful little musical, "Into the Woods," by Stephen Sondheim, incorporates many fairy-tale characters into its storyline. The stories of Little Red Ridinghood, Jack (think beanstalks), Cinderella, Rapunzel, a witch, a Baker and his wife, and others, are intertwined.
(songs in the order they are sung in the musical)