Hi guys please check out my site I need help!

Okay here is my site so far…I am totally new to this

https://www.collegeblogusa.com

my goal is to eventually have the gategory “choose your topic” that you see on the homepage linked to every school in the USA, so people can sign on and talk about their school.

you see on the right that I hsve the list of states which leads to all the colleges in that state.

how do I go about creating thousands of these pages so I can link them to each school?? Without having to do each page 1 by 1?

someone told me there is a code or script i can write to make this happen…he told me to make a list of every school in wordpad but he hasn’t gotten back to me on what to do next! ??

any help is much appreciated, thanks a lot!