I'm not sure about a "consulting" detective, but there are probably close to a hundred mystery series nowadays based around on virtually every aspect of modern, er, female life, from shopping (Elaine Viets Josie Marcus series) to scrapbooking to drinking coffee to making donuts/cake/cupcakes/any sort of baked good)
Seriously
Donut = Jessica Beck
Cupcake = Jenn McKinley
Cake = Jacklyn Brandy
Pie = Carol Culver
Yoga = Diana Killian
Ballroom Dancing = Ella Barrick
And I could go on and on and on(I was just reading recommendations off of the Elaine Viets books).
Probably sound a bit sexist, but they do exist (and my mother liked them) .
But something a bit better though, is Carole Nelson Douglas. She started off as a fantasy writer, but moved to doing mysteries. She has a series about a detective cat, but also a series about Irene Addler, from the Sherlock Holmes story A Scandal in Bohemia. That might be what you are after.
http://www.amazon.com/wiki/Carole_Nelson_Douglas/