Andrew is happily so far down the line we don’t need to worry. It’s Charles (whose reign is not likely to be long) then William and then his kids in order of birth, then Harry and any kids he has in order of birth... and then Princess Anne followed by her kids in order of birth (and the children of her son). Then and only then would it be Andrew who is 8th in line to the throne.
Anne comes after all her brothers and their kids. Charlotte is the first child in the line where sex doesn't affect the order of succession. The new rules weren't made retroactive.
But Andrew is still 8th: Charles, William, his 3 kids, Harry and his kid and then Andrew.
I don't know why I care about this. The rules of succession in the Bush and Clinton families have far more effect on us.