I have a lot of evaluation sheets I want to consolidate into one master sheet.

In every workbook only one sheet is used, same cells are used throughout but
they are split up into several tables with different headlines.

Ex:
Row 4 - title
Row 5, text in cell A, one of the cells B C D E F will have a 1 in it

Row 8 - title
Row 9, text in cell A, one of the cells B C D E F will have a 1 in it

and so on.. Layout is always the same.

I want to summarize the 1s in a master sheet so I know how many of each
reply there is. I only want to consolidate the cells where I have numbers, I
do not want to bother about the text cells.

Can someone help me with this?

Thanks!