How do I combine splitting data into files then splitting the new files data into multiple

I need help combining activities.

I have a source workbook “Test1.xlsx” I need to reference column A to split the data into new files.  I found code for that.
I worked out a way, albeit less than elegant, that keeps the formatting of the original sheet.
I then need the data in the new file’s main worksheet to be separated into multiple sheets based on Column B.  I found code for that.
Then I need to copy a static worksheet into each new file.

here are the bits of code I am using

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any hope??