“Motherhood is near to divinity. It is the highest, holiest service to be assumed by mankind. It places her who honors its holy calling and service next to the angels.” In Conference Report, Oct. 1942, pp. 7, 11–12. As quoted by Elder Boyd K. Packer - November 1993 Ensign and also by Elder Joseph B. Worthlin - November 1997 Ensign
David O. McKay also said, "Let us also teach girls that motherhood is divine, for when we touch the creative part of life, we enter into the realm of divinity." (“Chapter 14: Preparing for an Eternal Marriage and Family,” Teachings of Presidents of the Church: David O. McKay, 135)
President Faust addressed this topic,
"For the daughters of God, doing the Savior’s work does not, of course, include the use of priesthood keys, authority, or powers. But it does include building faith by testimony and example. It includes teaching the doctrines of salvation. It includes following the Savior’s example of love for all mankind. It includes ministering to others, for, as the Prophet Joseph said when the Relief Society was organized, “This is a charitable Society, and according to your natures; it is natural for females to have feelings of charity and benevolence.” 2 “Let the weight of your innocence, kindness and affection be felt … ; not war, not jangle, not contradiction, or dispute, but meekness, love, purity—these are the things that should magnify you in the eyes of all good men.” 3
This charge to the women of the Church carries a promise. Said the Prophet Joseph: “If you live up to these principles, how great and glorious will be your reward in the celestial kingdom! If you live up to your privileges, the angels cannot be restrained from being your associates.” 4Your God-given role as nurturers has never been more needed. This gift is unique to your womanhood. Men are not so richly endowed with these gifts. The highest expression of this gift is motherhood, but it is also manifested in many other ways." (1996 November Ensign).
One of these talks goes on to talk about how sad that some women in the Church do not feel as important as men. I think it's President Faust's talk.