I'm not entirely clear what you want to do but ASAPUtilities click here may help you.
In ASAP, Sheets -> Summarize rows or columns from several sheets.
This utility will combine the selected columns of each sheet into a new sheet (summary).
Select the desired sheets.
Start this utility, then select the column(s) you wish to summarise.