Printing all selections from a drop down list

[soccermike]

I have an excel sheet that is an exercise program for a sports team. I have a drop down box where I can select an individual athlete and certain values/cells change to specifics for that athlete. These individual characteristics are on a separate sheet. I need a macro that selects each athlete and then prints the sheet with his/her specific values on it, instead of selecting each athlete and then printing myself.

I'm new to macros and have never written one. I need help!

I've attached a sample excel file.

 

[Chihiro]

Something like below.

Change Range as needed.

Sub DropDownChangePrint()
Dim dList As Range
Dim pWs As Worksheet
Set pWs = ThisWorkbook.Sheets("P2MR")
Set dList = ThisWorkbook.Sheets("Max File").Range("A2:A10")

For Each Cell In dList
    pWs.Cells(1, 12) = Cell.Value
    pWs.PrintOut
Next Cell
End Sub