Data From Various Sheets
 

Hi - hopefully there is someone who can assist. I have a question about data.

I have a tracking spreadsheet with 5 sheets, the back for are for different
subjects but each shows the actions due each month and each month the actions
completed are entered.

This pulls together into a front sheet which all works fine, but I can not
find a way to total up the total actions complete on a month by month basis.

For example

Jan Feb Mar
Sheet 1 Actions due 2 1 3 (cell
A1,A2,A3)
Sheet 1 Actions complete 1 1 2 (cell
B1,B2,B3)
Sheet 2 Actions due 4 7 2 (cell
A1,A2,A3)
Sheet 3 Actions complete 4 0 6 (cell
B1,B2,B3)


I've put a drop down list in one cell on the front summary sheet, how do I
then use this is the next cells to show how on track things are?

So in Jan there should have been 6 actions complete and 5 are. In Feb there
should have been 14 actions done (Jan and Feb figs combined) but only 6 have
been. Obviously this will continue to years end.

Any tips at all??? Thanks in advance.. Noy