Pivot tables

Hi,
it's friday 5:30 and i didn't look around for previous resolutions,
as I donT' know how to describe it.


I need to figure out the work load for a week.
That would be the planned tasks for the week completed and opened,
PLUS the ones that we're completed from previous weeks planned.

I can get those from another pivot table on sheet 4, that tells me for a week how many we're completed from every week scheduled. But that is not something that will update itself automativaly.

I'm stuck, i don't know how to make this happen.

Simon