Combining charts from different sheets

I have a workbook with 96 sheets, each with two columns of numbers -in
columns b and c.  The numbers are information for a frequency diagram (a
histogram) where b is the datum, and c is the frequency.  There are 256
rows
in each column.  

I need a way to graph subsets of histograms - anywahere from 2 to 24 at a
time to be exact - on one graph.  I've been doing it all by hand - moving
each pair of columns to a summary sheet then highlighting to "add data"
but
now that I've got 96 of them, I really need a function or a macro or
something.  Can anyone help ?  Thanks