I'm trying to create a macro that will do two additional things. 

 

First I have a cell (A2) that is changing based on a vlookup formula and I would like the name of the Excel tab (not the whole Excel worksheet) to change to whatever Cell A2 is equal to. 

 

After the tab name is changed, I want to print the worksheet to pdf (I currently use Do Pdf, however, have read that it isn't compatible with what I'm trying to accomplish.  I'm willing to add another pdf program to my PC in order to accomplish this) and name the pdf file the same as the tab name that changed in step one. 

 

Any help with coding, etc would be greatly appreciated!  Thanks!