Mass Create PDF Loop

Hi Everyone,

Here is what I am hoping to accomplish. Currently I have a print macro within VBA that will formulate names from a named range “listAthlete” in a listbox and allow me to print a sheet for each athlete chosen. I would like to have the same or similar set up, but instead of printing the sheet, I would like excel to create a PDF version named after the person(s), and save the copies in a folder. Any help would be greatly appreciated! Attached is a excel copy with some dummy data.