I want help regarding salary slip generator that I am preparing for my organization. I sheet 2 I want that I can search by name and generate salary slip of an employee. This I have already done.
In next sheet I want that all the salary slips of the employees in the organizations are generated to be printed in one go. Also, I want the same format as in sheet 2 viz heading and logo for each of the salary slip generated. Is it possible using Macro. I am not able to do it. How can logos come in individual salary slips? Can same format of the salary slip be maintained? Also, how will the things work when the number of employees will increase which is likely to be next month.

I will be really grateful for the help.