How do I pass contents of a cell to a string and then use that string value to search

I have a sheetA of string values(Test Names) in a column. In sheetB I have the same string values(Test Names) in the top row. Each Test Name is mapped to some codes that are listed below it -one in each row.

I want to find the Test Name in Sheet A, in Sheet B, then copy all the codes mapped to it in SheetC. Then I want to copy values for the Test Name in Sheet A(in 2 consecutive cells) and paste them in the corresponding cells in SheetC. I have attached a file here with the 3 sheets.

Thanks in advance.