Excel - Print to pdf after updating cell values based on different cell value.

Hi members,

I have an excel sheet for invoicing with linking to different sheet which is having data for all the invoices raised. Currently, I feed data in the databases sheet and then manually change invoice number in invoice sheet for printing one by one.

How can I automate the process of changing invoice number between a specific range from database sheet and then print to pdf automatically.

Thanks in advance for you support.