Compile (sum up) multiple sheets into new sheet

[agrotto]

HELP!

I have 12 sheets of statistical data in a workbook (Jan-Dec) that I want to compile/compress/sum into a Year report. These sheets have data in Rows (Patron Type) and Columns (Databases Accessed) with numbers at the intersection showing how many times this patricular patron type accessed a particular database.

Unfortunately between the different worksheets (months) the column and/or rows are not consistent in terms of what column and/or row headings appear in a given month.

Is there an easier way to do this than re-enter and compile this data by hand? I just can't get my head around the best way to do this.

Thanks for any help you can offer.

-Bill