I have 2 seperate macro's.
Macro2 -creates a worksheet for each PCT
Macro1- creates a workbook for Health Authority.

I would like to combine the two, so that after extracting data needed
to create each workbook I use it as the datasource to create the pivot
table.

Macro 1 is based on the example-Create a new sheet for all Unique
values
Macro 2 is based on the example-Create a new workbook for each value
both on http://www.rondebruin.nl/copy5.htm#workbook

Is there are way to integrate the macros so that it a workbook is
created with macro 1 and then within this new workbook, worksheets are
created for each HA using macro 2? Also I wondered how I would going
about using a template to generate the workbooks.

TIA