Saving specific sheets as PDF with file name consisting of cell info

Hi all,

I have created a template that will need to be filled out on a regular basis and emailed to the customer.
The Template consists of 2 tabs: "Data" tab and "Print" tab.
The information will be put into the "Data" tab and the "Print" tab will pull all info and place it into the specific cells.

Is there a way to create a button on the "Data" tab will save the "Print" tab only as PDF, while using information from specific cells as the name?
For example: Date/Part #/Rev #.pdf

Thanks,
Yuriy Baron

This is perfect!
Would it be very difficult to add a button to the Excel spread sheet to execute this?

Thank you very much for your help!!

I got the button working, and was able to edit the code to fit my needs. I have noticed that it is not saving into the correct directory. The File seems to be going into the documents folder instead of the location of the excel file.