add sheet and change print area based on number of line items in template

I hope this is clear enough to get what I need across

I currently run a template macro (attached) and my customer has asked me to print a "CERT" (sheet2 named CERT) for each line item in column B on sheet1.

If there are two "SHIPPER REF NO" in column B then I need two separate "CERT" (one for each ref no), if there are three, I need three etc.

It is not important as to whether the macro adds a sheet to the workbook, or just adds an additional page to print on the same sheet.

I have absolutely NO IDEA where to start to make that happen. I have attached the file, as well as the macro I am currently running for this template. Any and all help is most appreciated.

Hi,

The attached has a macro that I've used if I needed to make separate sheets for each agent. Concept wise, I think this is what you needed.

Hope this helps

That is not exactly what I needed, though it does help a little.

I have attached a copy of what I need the final product to look like once the information is entered in on the template (SHEET1).

It would be ok for the macro to populate a second page on the COL-TPA worksheet in place of making a second worksheet also.

I hope this clarifies.