Fill Certain Cells on Form Sheet based off Data entered in table on Another Sheet

[USFengBULLS]

Hello All,

I have another question concerning filling data from one sheet to another. Sheet 1 I created is basically a transmittal form, Sheet 2 is a list of sample materials that will need to get approved or rejected once sent. The user will go in at the start of the job and fill on the sheet 2 will MR Code (Sheet2 Column A), Description (Sheet2 Column B) and AC Code (Sheet 2 Column C).
Now Back on the Transmittal Form, Sheet 1, there is a an area that the user will fill out up to 5 materials at a time to be submitted for approval. Sheet 1 B23:27 = MR Code, D23:27 = AC Code, E23:27 = Description. What I am trying to achieve is the user to have the ability to select certain materials (Up to 5 at a time) on Sheet2 Material list and have it automatically fill this area on the Sheet 1 form with what ever selection they selected from that list.
For instance, Sheet 2 has:
MR Code: Description: AC Code:
M1 Blah W1
M2 Blah W2
M3 Blah G1
M4 Blah G2
S1 Blah S1
S2 Blah S2
And the user comes in and wants to select Lines M1, M3, & S1 to be submitted for approval. So Somehow either a check box or another way of selecting that you guys suggest, he selects lines 1,3,&5 which are the M1,M3 and S1 materials and it copies data in these cells over to Sheet 1 the Transmittal form in the correct areas (That B23:E27) described above.

You guys have a suggestion how to first off select these rows and then how to begin coding to whatever is selected to automatically fill that area on the form? Thanks