still cant figure out pivot table working

[mychals]

tried a few times getting formulas or a pivot table to work.

here is an example http://www.crlaurence.com/adv/example.xls

trying to enter something into cell A2 (like A12* or A123)

then it would look at column G, and then find all matches, and in order display column H and I info and put this info into columns B and C


Thank you