Formula for sumup of data based on wildcard criteria

[jibranchohan]

hello everyone;
I got stuck in creating of formula based on the below-mentioned criteria;
I have column B in sheets named " Sindh, KPK, Baluchistan" which is getting data of patients date-wise of different UCs of different districts.
I want to create a formula that could help me to add(sum up) the date-wise data based on wildcards such as " Karachi, Thatta, Badin, etc."
mentioned in columns C3, D3, and so on.. in the sheet named " District Wise Consolidation". these sheets are getting updated date-wise.

for now, I need to update the basic formula in each sheet and in each column of the district and province-based sheets which is tedious and hectic to do so on a daily basis
can anyone help me in this regard I am stuck badly please please help me as a reference I am hereby attaching the sheet which could use to populate the results and can share it back.

[JohnTopley]

in C5

=SUMPRODUCT((--(ISNUMBER(SEARCH(C$2,Sindh!$C$2:$AT$2))))*(Sindh!$B$3:$B$33=$B5),(Sindh!$C$3:$AT$33))

copy across to G and down

Similar in J5

=SUMPRODUCT((--(ISNUMBER(SEARCH(J$2,Punjab!$C$2:$AT$2))))*(Punjab!$B$3:$B$33=$B5),(Punjab!$C$3:$AT$33))

[jibranchohan]

Dear John Topley;
Thanks for the reply this formula exactly served the purpose. bundle of thanks once again stay blessed.