Queen Elizabeth II ruled over a time of huge cultural shift when women were increasingly stepping into leadership roles