Link Check Boxes to Cells automatically

I have a requirement to use the check boxes for the user input and derive value (yes or no)and use it as input to the formula calculation.I checked online most of the places it shows link check boxes manually but I have dynamic requirement I need to add thousands of check boxes I could not find a solution.

Example here:- colA,ColB,ColC all cells check marked (i.e Yes) but how do we link check boxes automatically ?

ColA1=IF(colA:colA="Yes","a;","")
ColB1=IF(colA:colB="Yes","b;","")
ColC1=IF(colA:colC="Yes","c","")
Formula = colA1:colA1& colB1:colB1& colC1:colC1&

Result =a;b;c

Please suggest me any tips.

Thanks