@OP,I would recommend spending a bit of money if you can afford it, and seeing a private consultant. I have been on HRT for years, my HRT was not working and I then needed a hysterectomy, so my HRT had to change afterwards (no progesterone after hysterectomy). My consultant ordered blood tests which showed that my oestrogen levels on current HRT were way too low. I’m now on an increased dose, and even though I’m in full menopause (due to the hysterectomy) I’m sleeping better, feeling generally good, no night sweats.
Testosterone isn’t always the answer - I’ve been tested twice and have plenty of it. But tweaking estradiol and progesterone may resolve your issues, if you find the right doctor.
Also, different people will absorb oestrogen differently. I like the patch, others prefer the gel. It’s trial and error. My consultant was scathing about oral oestrogen though, said it shouldn’t have been prescribed in the first place.
In relation to sleep, the NHS will prescribe Daridorexant and Amytriptiline (sp.?) to help with sleep in menopause. I’ve found using them together helps tremendously, after a decade of crippling insomnia. Amytriptiline does give weird dreams though - not nightmares, but intense. My sleep isn’t perfect, but it’s better than it’s been in a long time.