There should be clear workplace policies to support women going through the menopause, according to an MP.