SUMIF across multiple worksheet

[NFIAu]

Hi,

I'm trying to set up a budget tracker which could be for up to 10 various programs.

Each worksheet has the below information with a list for the service such as DATS (there are also MH & AH). On the summary sheet I will have tables for each of DATS/MH/AH programs etc and want to pull the budget shown on the subsequent sheets if it relates to that program into the same layout as on each of the individual sheets.

Service	DATS
	Funding	OoS
Budget	0	40
Claimed	$0.00	13
Remaining	$0.00	27

<colgroup><col span="3"></colgroup><tbody>
</tbody>

Thanks so much to anyone who can help me stop pulling my hair out!!

 

[arthurbr]

Perhaps http://www.xl-central.com/sum-single-criteria-multiple-sheets.html