Don's suggestion of using a CountIf() would work well although, having
said that, it would depend greatly on the layout:

Heres a little on-the-fly suggestion:

CCI Info Sheet

A B C D E F G
1 1 2 3 4 5 6 7
2 1 2 3 5 6
3 3 7
4 1 2 4 6
5 3 4 5 7

Master Sheet:

A B C D E F G
1 1 2 3 4 5 6 7
2

A2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=1")
B2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=2")
C2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=3")
D2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=4")
E2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=5")
F2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=6")
G2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=7")

The above assumes both sheets'row 1 is header details.

The result of the above give you the following:

Master Sheet:

A B C D E F G
1 1 2 3 4 5 6 7
2 3 3 4 3 3 3 3


You can look at this from other value perspectives, by that I mean you
could mark each intersecting row/column with an "X" or just a "1" in
which case you would change the countif to the following:

A2 = =COUNTIF('CCI Info'!$A$2:$A$30000,"=1")
B2 = =COUNTIF('CCI Info'!$B$2:$B$30000,"=1")
C2 = =COUNTIF('CCI Info'!$C$2:$C$30000,"=1")
D2 = =COUNTIF('CCI Info'!$D$2:$D$30000,"=1")
E2 = =COUNTIF('CCI Info'!$E$2:$E$30000,"=1")
F2 = =COUNTIF('CCI Info'!$F$2:$F$30000,"=1")
G2 = =COUNTIF('CCI Info'!$G$2:$G$30000,"=1")

OR

A2 = =COUNTIF('CCI Info'!$A$2:$A$30000,"=x")
B2 = =COUNTIF('CCI Info'!$B$2:$B$30000,"=x")
C2 = =COUNTIF('CCI Info'!$C$2:$C$30000,"=x")
D2 = =COUNTIF('CCI Info'!$D$2:$D$30000,"=x")
E2 = =COUNTIF('CCI Info'!$E$2:$E$30000,"=x")
F2 = =COUNTIF('CCI Info'!$F$2:$F$30000,"=x")
G2 = =COUNTIF('CCI Info'!$G$2:$G$30000,"=x")

If all this fails to help, you will need to give us a look at the
workbook so we can suss it out.

HTH
Mick.