Another 52 year old functioning on what must be the lightest, most disturbed, most-interrupted, least nourishing sleep on the bloody planet!
Clare, I so sympathize! What you wrote is exactly what I went through (but I could never have worded it all so well!). I tried everything I knew. The homeopathic stuff made me feel weird, unfortunately. Went to the doctor for sleeping pills but the doc said to me, "I sleep 5 hours a night too, so what's your problem"!! So I went to another doc and the second one (a female) was great and wrote me a prescription for acupuncture. This was completely new to me but at that point I was game to try anything. Acupuncture (with a terrific, well trained therapist) was super helpful for me. I got some relief right away - went from sleeping no more than a total of 5 hr./night for 3 years to sleeping 6.5 hrs. after the first treatment. Yahoo!
And yes, the workouts were essential. They helped in so many ways, including helping my mental health. The positive thing is that it inspired me to work out more intensely and get into hiit training and using heavy weights which I now can't imagine going without.
I also found (to my dismay) that my body could really no longer handle sugar, so I tried to cut back on that and increase water. When I could restrain enough to do it (not easy when sleep deprived!) I did sleep better. And my body/health is all the better for that. Menopause forced me to live healthier so I guess that is the silver lining.
Once I retired I slept and slept and slept for the first several months! It was astounding how sleep deprived I had been for so long. Knowing I could sleep in and having less stress really helped me get my sleep.
I think menopause can be brutal for some women and the challenge of it is really underestimated. For me, it was one of the most challenging experiences of my life. Without sleep, your whole world changes - sleep disruption affects every aspect of your life. It can take a lot of work to find something that will help you as an individual. For me it was: acupuncture, eliminating added sugar, increasing water, restructuring things to decrease stress, changing my schedule some days so I could sleep in, and most especially, patience - eventually the hormonal changes levelled out. Good luck and sweet dreams!