check the golfdigest.com or golfonline.com sites. they have 'in the bag' equipment sections that have some information about shafts and other equipment for the popular players.
As far as I know, a lot of pros use True Temper steel shafts. It seems to be almost the default shaft for most clubs. I would assume women use True Temper Dynamic Gold S300 shafts, but that's just a guess.