combining then grouping/summing spreadsheets

[t16turbo]

hi all,

bit of a tricky one (for me).

I have 6 spreadsheets - lets call them book1, book2, book3 etc
each one contains information in this format (i'll only list the important info)

FOB_CODE, TOTAL, OCT05, NOV05, DEC05, JAN05, FEB05, MAR05

P1, 145, 34, 35, 34, 43, 50, 31
P1, 321, 4, 5, 12, 57, 66, 77
P2, 300, 10, 10, 11, 20, 20, 20
P13, 765, 100, 123, 122, 140, 107, 112



There is an additional spreadsheet that contains the following info:
ref, groupdesc, program, sheam
P1, Sapiens, Sapiens, Committed Projects
P2, Xenomorph, Xenomorph, Committed Projects
P13, Client dev, Client dev, Committed Allocations
G14, Central Management, Central Management, Committed Allocations
G15, Central Maternity, Central Maternity, Committed Allocations
G16, Central TA (minus oracle), Central TA (minus oracle), Committed Allocations



I have to take the combined data in the 6 spreadsheets (book1, book2 etc)
put them together,
and then using the FOB_CODE field, link to the scond spreadsheet to SUM the TOTAL and OCT05, NOV05 etc field by 'sheam' and then by 'program'

eg.

Category, Program, OCT05, NOV05, DEC05
Committed Projects, Sapiens, 38, 40, 46
Committed Projects, Xenomorph, 10, 10, 11
Committed Allocations, Client Dev, 100, 123, 122

please can someone show me how this would be acheived.

so far, I have written the code to open all of the BOOKS involved.

any help will be gratefully appreciated...

hanks in advance....