Build an excel workbook with macros to automate bill printing based on data of payments received

I need someone to build an excel workbook with macros to automate bill printing based on data of payments received. Details such as Bill/Invoice number, Date of payment received, Name of Payor and Amount of payment received will be in a separate worksheet. The second worksheet needs to have the invoice format with macros on which the actual invoices can be printed automatically to pdf based on the first worksheet.