Hi

it would be

=SUM(SUMIFS(INDIRECT("'"&G5&"'!d4:d100"),INDIRECT( "'"&G5&"'! b4:b100"),B3,INDIRECT("'"&G5&"'!e4:e100"),{"walk", "fast walk"}))

And your sheet is ' TIM A', delete the space.

Also if there is a space in sheet name we need to wrap the sheet name in single quote while using formula INDIRECT.