Before you rip everything apart, check all the wires going to your transmission. I had a cut/pinched wire in split loom I couldn't see, not sure how, perhaps a stick r rock got up there, but, Same symptoms, only 1st gear (42RLE).
Edit: Check the connectors as well, and while you have them off...