Need help with invoicing totals to another workbook

[djmikey]

Hi
I have just set up my invoicing and I would like to take the total of weekly invoices and place the totals into a monthly budget workbook.

As the invoice amounts are changing but the cell with the total doesn't, do I still use the fx calculation of SUM to make this work?

Thank you in anticipation of working answer.

Regards
Michael