Despite being a Yale SOM'er, I rarely toot Yale's horn on this board. If your ultimate goal is to transition into social impact, I think Yale SOM would be a wise decision.
Short term:You stated your goal is to get into consulting. Any one of these schools will get you into consulting. I said this before, assuming you're in a top 10 program, getting your ticket punched into MBB depends on the following:
1. Ability to network (having at least decent EQ)
2. Quality of CV
3. Ability to case & interview
4. Luck (quality candidates can run into awful interviewers or simply don't jive with them)
Long term:While interest in tech and consulting has increased, there's still an inherent interest in social impact and non profit at Yale SOM. Plenty of our classmates go into those fields (along with CSR) and you'll have no problem building meaningful network that can be of use in the future.
---
With all of that said, I think the most important thing is community. If you don't feel at home at Yale, this might not be the right school for you. Same goes for Kellogg and Tuck. If you feel like Kellogg's community blows that of Yale and Tuck out of the water - don't worry about paying partial tuition, you'll pay that off quite easily with a consulting job. The reason I emphasize community is that you'll be spending the next 2 years with these people. Your classmates will make or break your business school experience.