Formula to get the sub total of a rown from several PT

Hi all,
I have another quiestion about the scaffold control table..
on the second tabe i have 3 pivot tables:
1) shows me the ones that were build during the current week.
2) shows me what was dismantle this week
3) shows me what was build in the past weeks but are still active this week

so i addeed a "week #" column so i can sort them like that.

Questions:

-how do i get the sum of a row and display it at the end?
for example "HRSG" its in 3 tables..i wanna a formula that looks for this word, and them sum the subtotals..

-is there anny way u can think of, to combine all tables and get the same info?


thanks for your time!