I found that opening quote by Campbell somewhat surprising. I'm a big fan of his, but here he seems to be confusing actual women with the goal of the journey, which is a psychological/spiritual figure.

One ancient myth/fairy-tale in which a woman makes the journey is that of Psyche – an interesting name in itself. I wrote about her here and here. If you're not aware of her, you might find this interesting.