how to create and what is the formula in creating payslips using excel macro / vba programming in excel?

like for example, in sheet1 is the payroll data, and in sheet2 is the payslip template and in sheet3 would be the run button.

please help me with the formula wherein all the payroll data that i want to appear in the payslip will be shown.
thanks