Print in PDF based on selection of one or more if possible at Path Local incl cloud drive

Hi,

For first PART-1

Pls refer the file in the link mentioned below.

I have to print in PDF as per the selection in A5 column onwards check box fully or partially when clicked from Master worksheet in a specified formatworksheet.This is for a single Unit.All the codes with sample file are mentioned in the link >>
https://docs.google.com/spreadsheets...it?usp=sharing

OR,

https://1drv.ms/x/s!AlMkmnpeQjaS4AxYLuyDDlMFlwWz

For 2nd PART-2

Pls refer the file in below attachment mentioned.

Now the same thing I want for a multiple units which has been mentioned at A1:A4 which has a multiple format worksheet each are different whose names can be Format_A,Format_B,etc.Hence,added checkbox to select that unit whose statement are required.The columns from Right to G column automatically appears.

I want to get in exported to pdf accordingly at dynamic unit path folder for each unit if possible at cloud drive too.

Also,I have inserted rows above and few columns has been altered and updated for making a for a multiple unit in worksheet 'Data_N'.

Kindly revise the code as mentioned in above link and insert in enclosed attachment.

NB:The codes in the files are the great contributions made by forum contributors from this forum who has given their valuable time in solving each issue raised.