There are actually 124 current merit badges, and yes, your son has to be approved by a merit badge counselor specific to each badge.

I suggest your son - not you - talk to his Scoutmaster about his goal of earning all the merit badges. Between him and his Scoutmaster, they should be able to work out a plan to get him started on that long trail.