Your symptoms could also be stress related. I am also early 40s, and I found that I could no longer handle as much as I used to, my sleep was affected and I got very tearful. It's taken some years, but I did not go down the HRT route on advice of my GP. I read up on menopause (Christiane Northrup and Sara Gottfried were the best) and worked on getting to know my older self and looking after myself.
I have worked a lot on my thinking. Every night I write down 3 positive things from my day. During the day I try to reframe negative thinking and praise myself. If my brain starts negative thinking at night, I stop it. I use a trick of counting backwards from 20, I don't know why it works, something to do with the frontal lobes, I think, but it does work. I also think of a good film/story and retell the narrative in my head. I keep telling myself that I am a great sleeper and that I will wake up refreshed after a good nights sleep.
You could also try meditation (didn't work for me), there are many apps to get you started, a guided meditation is a good start.
Also I prioritise exercise, I go swimming (and then sauna) 2-3 times a week. Really sorts out my head!
With the night sweats, try a light summer duvet (down or silk).
Vitamin B6 might work for you, it really helped me, as did Spatone iron and magnesium lotion (Better You).
I think at our age we have to look at the whole picture, diet, exercise, thinking patterns and life choices. Are you happy in your job? How are your relationships? You are at a point in your life where you can no longer settle, you can no longer compromise.