Multiple Print From Data Validation

[Burnsieboy]

Hi,

I have an annual leave workbook that keeps holiday details for around 60 staff
There is a worksheet for each of the 12 months where leave is entered -
Staff members in Column A, other varying data in columns C:H, leave is captured in columns I:AN
I have an additional sheet called "Individual Leave Summary" that is changed based on the cell A3 of that sheet, this cell is a dropdown.....

I'd like help with a vba solution to print, save & close each of the staff summaries to pdf using cell A3 as the file name

So, Print "Anderson, Anders" then print "Boo, Betty" then print "Connors, Chris" etc

Thanks