UPDATE::
The Example in the Answer below works, But it may be from a result of some sort of BUG in Pages.
I did not save the test document when I did this until now.
It seems when you reopen the Document. It saves the result in the total cell of Table A, as text. i.e removes the formula.
So the REAL answer is NO. you cannot do this in Pages.
You CAN do what you want in Numbers
Original Answer
In the cell of Table (A) the table you want the sum; type a equals symbol. =
You will now get a the formula box.
(cell in table A)
Type SUM(headerTitle) in front of the = with no spaces.
(cell in table A)
The headerTitle being a Header Title from Table (B)'s Header Row or Header Column.
In this example I use Table B's Header Row title 'headRowTitle2'
(table B)
(The Row in table B will highlight to show the cells Table A will be using)
Click the green tick button. It should now display the total you want.
(table A)
You can create a symlink of the actual pages template directory on your Mac in your Dropbox so that you don't have to maintain two copies of your templates, and then use Dropbox to open the template files in Pages to make a new doc based on the template.
Though template files are saved as .template, Pages for iOS still opens them correctly. You can create the symlink with the following command:
ln -s ~/Library/Application\ Support/iWork/Pages/Templates/My\ Templates/ ~/Dropbox/Pages\ Templates
Best Answer
Depending on your current Pages version, download CiteInPages from here...
http://jhh.med.virginia.edu/main/CiteInPages
I was able to get this to work in Pages 5.5 using CiteInPages5. It works with BibDesk. It takes a bit to install and configure it, but its a great little package. Apple really should change the name of the Pages app though. Its way too difficult to google any support for it.
EDIT: Hopefully you see this because I don't have the reputation to comment. But I guess I misunderstood your question. Its been a while since I've used CiteInPages, but I was able to get the formatting I wanted by creating a custom template. I was able to do this with some guidance from the BibDesk community mailing list. Here's a rudimentary template for the CSE style that I created.