Hi VBA champs..need help in designing "Macro to group rows and columns based upon each Row/column value in corresponding cell value for multiple sheets in workbook "

1. Each row should group independently for particular cell value say(0) in column "B" of same worksheet and ungroup for "1" automatically. (Row 2 should group/ungroup based upon value in cell "B2" ..Row 3 for cell "B3"and so on
2.Each column should group for particular cell value say(0) in row "B" of same worksheet and ungroup for value "1" automatically. (Column C should group/ungroup based upon value in cell "C2", column D for value in cell "D2" and so on
3, Need 1 summary sheet...which should have option for which all sheets to apply grouping conditions for above. (suppose need to exclude some sheets for above rules)

Thanks in Advance