Can I create a macro to save multiple PDF's (different names) from a single excel template?

[JGer]

I am not well acquainted with macro's but am looking for a quicker solution to saving multiple PDF's from a single excel sheet.
The excel sheet extracts information from multiple other excel sheets to create a summary per client per orchard of essential data.

Currently I have to copy and paste the client name and Orchard number for every orchard and then SAVE and name the PDF.

This must be done for over 1000 PDF's and needs to be updated regularly so is very time consuming.

I would also like to be albe to print a hardcopy of each sheet using a Macro if possible. Currently printing follows the same procedure as saving PDF's.

 

[ER_Neha]

Hello, to understand your question better , can you please tell me if I am correct or not

1. You want to save every excel sheet as different pdf
2. The name of the pdf file is according to the sheet name
3. You want to print each sheet

Are these your requirements ?

 

[JGer]

Hello, to understand your question better , can you please tell me if I am correct or not

1. You want to save every excel sheet as different pdf
2. The name of the pdf file is according to the sheet name
3. You want to print each sheet

Are these your requirements ?

Hi.
In the Screen shot there are 2 blocks highlighted in blue. These are the variables to the sheet. As they change the data displayed on the rest of the sheet changes. The data is stored on various other tabs within the workbook. This image is of 1 clients data. For every block listed in column R both a PDF and physical print out are made.
So to your questions:
1. Not the different excel sheets of the workbook, only the one displayed in the image attached here is saved and printed multiple times (every time the data is changed by changing the info in the blue blocks).
2. The name of the PDF is according to blocks that are blue in the image (plus some other information which is standard for all sheets)
3. Yes.