Linking Certain Data Between Two Tables.

Hello-

I'd like to populate specific sets of data for each group (>100 groups in real data) from master table to a simplified table.
I have created the forrmula to link to specific cells to show what I like to accomplish. Reference workbook is attached.

I like to be able to drag down the three cells for the rest of the groups. How can I achieve that?

Thanks in advance for all replies.

P.