Saving Worksheet as different pdfs

Hi All

Theres currently a report which has some manual works that I am hoping to automate to make life a bit easier. I am not sure if this is possible or not but I figured Id let the experts around here answer that.

I have a workbook which has different information on different team members.
What I have done is created a summary sheet with data validation in one cell where you can come and select the team member and then the rest of the sheet only reflects the data for that member. So sorta like a dashboard

Because the team members cant see each others numbers, I save the worksheet as a pdf and email it out. The problem is I have to do this 25 times as I have to create a separate pdf for each member.

To give you a little information on saving as a pdf. We use the FreePDF XP plugin. So it shows up as a option when you go to File > Print. Once you hit ok.. a box shows up where you click on save to file and then type in the filename and hit ok. If there is a better plugin to do this please let me know as well.

So in the end If could save the sheets seperately where the file name would be the value in the data validation cell, that would be awesome.

Is this possible>?

Any help is greatly greatly appreciated . Thanks

Please let me know if any further clarification is required.