Vlookup Multiple Values with VBA

I am worst in VBA, at my job we get report in excel and we need to fill in the form using report, I tried to automate using formula but it increases the size of Sheet and at a point calculation stops because of too many formulas , it doesn't provide me required value,
I am looking for VBA, I have googled and found most vba part script that I require, Last thing I am looking for is VBA script returning multiple values.
I past report in Sheet2 and when I click Command, forms should be Filled.
Under Sheet1, Cell C2 Will have of Name of Applicant, and Cell Range A4:A15 should pull all corresponding Values from Sheet2

splash_b,

Upload a sample file with some dummy information, and someone may be able to interpret what you require, and provide you with an adequate solution.

Rgds,
Xrull

Attached is the sample file, There may more data