Selection of data on different worksheet

Hi there,

Anyone can give me help me with this issue, I am trying to do a reporting to the management and I was thinking of using the scrollbar so that I can get the result on the same worksheet without having to scroll from one end to the other to look for the result.

Attached the file for easy referencing.

I know that the combination formulae of Index and if function can do but I do not know how to go about to construct the formulae.