Automatically save as pdf but include location
 

I have a workbook with 4 worksheets the first is called “input”which I use to enter information which goes to the other worksheets which are called body, curtains and doors

I am stuck on the following; after inputting the information I want to save as pdf’s in various locations.

Is it possible to have 4 buttons on the input sheet which automatically :
Button 1 - Save “body” worksheet as a pdf to a specified folder example G: Archive\Body using info from a set cell on the worksheet

As above for other sheets

Thanks in advance for any help and advice