I need my current formula to reference a specific range.

I have a schedule and i want my
1) from the data (utilities) sheet to go to the required week/sheet

2)find all the required tasks (eg: "vip*") for the said person
(each person has 3 columns: Task title, facetime, officetime)

it will need to search the task (column1) and add the time (column2) from the schedule

i have the formula that can do this [B]EXCEPT[B] for it to check the needed name on the data sheet and reference that with the name in row C and commence the calculations within the 3 columns under that name.

here is my ccalculation formula:
Formula: copy to clipboard 
=SUMIF($G$4:$G$359,"vip*",$H$4:$H$359)


the next step that i got was:
Formula: copy to clipboard 
=SUMIF(INDIRECT("'"&$A77&"'!$G$4:$G$359"),"vip*",INDIRECT("'"&$A77&"'!$H$4:$H$359"))


But it isnt checking within different ranges
Should I have a feeling i should be Matching
maybe something like this?:
Formula: copy to clipboard 
MATCH($C76,INDIRECT("'"&$A76&"'!$C$2:$DA$2"),0)


and if so, where should it be entered?
however im really stuck and just guessing now!

I'm Really Stumped! please [B]HELP![B]

The place where i want this formula is on my: Utilities sheet under the VIP column

here is my dummie workbook:Matching teacher to schedule range.xlsx