Repeating the Sheet 1 ref is problematic when passed to INDIRECT. Try:

=SUM(INDIRECT("'"&"Sheet 1'!H83:"&(VLOOKUP(RIGHT(D3,1),$C$8:$D$19,2,0)&"4")))

Regards