Need to compile a list of the sum of every combination from several matrices of data

Hi,

In a document i have 6 sheets. On each sheet there is about 5 rows and 5 columns of data. I need to compile a list of all the possible combinations when adding one from each column and row at a time to a total sum.

For instance. In sheet 1 i have:

.......................Column 1.1........Column 1.2
Row 1.1....................5.....................-2
Row 1.2....................3......................0

Sheet 2 contains:

.......................Column 2.1........Column 2.2
Row 2.1...................3...................2
Row 2.2...................4...................-1

The compiled list would look like this:

........................Column C1......Column C2
Row 1.1 + 2.1...........8...................0
Row 1.1 + 2.2...........9...................-3
Row 1.2 + 2.1...........6...................2
Row 1.2 + 2.2...........7...................-1

However since there is gonna be thousands of entries in the compiled list i have to automate this. I'm more than happy to invest some time in to learning how to do this, but i need somewhere to start.