Help with getting totals for different consignors.

[Btotl]

Hello,
I am trying to find & retrieve data (sold item price) from 5 different pages (i.e. monday, tues, wednes, etc) for independent consignors (i.e. san, box, etc.).
the table is like the following:

code desc. price
--------------------------------------
san shirt 8.00
box vase 12.00
san mug 4.00

then put it into a table on a different page for the weekly totals
i.e.:

code total
------------------
san 12.00
box 12.00


1.JPG3.JPG4.JPG