What is the Bible’s Authority on Human Sexuality

How do I read and interpret the Bible in a way that’s affirming of women in leadership and of LGBTQ+ people in the church?