Create individual worksheets from pivot automatically and generate account statement in words from individual sheets

[Ashish2002]

Hi,
In simple terms let's say i have multiple investor data with investment across different mutual funds, pan number is common identifier

Now once i create a pivot which groups by investor pan number and sub group by fund house name.

Now i want each investor data to be printed as account statement on a standard format in word.

Either way is to create individual worksheets via macro and then another macro to generate individual statement in word

Or one macro which can directly read from pivot and paste into word to create individual word statement and move to new page /new word document for another investor.

There will be obviously soome common lines in each statement saying below is your account statement......

Happy to upload a sample file if required, little urgent, will be thankful

 

[Ashish2002]

Sample excel and bill snapshot

Date	Amount	Fund	Customer Name	Customer Pan
5/11/2021	5000	Axis	Mr A	AA5555888
5/21/2021	6000	HDFC	Mr A	AA5555888
5/31/2021	7000	ICICI	Mr A	AA5555888
6/10/2021	8000	SBI	Mr A	AA5555888
6/20/2021	9000	Mirae	Mr A	AA5555888
5/11/2021	5000	Axis	Mr B	AA6666888
5/21/2021	6000	HDFC	Mr B	AA6666888
5/31/2021	7000	ICICI	Mr B	AA6666888
6/10/2021	8000	SBI	Mr B	AA6666888
6/20/2021	9000	Mirae	Mr B	AA6666888
5/11/2021	5000	Axis	Mr C	AA7777888
5/21/2021	6000	HDFC	Mr C	AA7777888
5/31/2021	7000	ICICI	Mr C	AA7777888
6/10/2021	8000	SBI	Mr C	AA7777888
6/20/2021	9000	Mirae	Mr C	AA7777888
5/11/2021	5000	Axis	Mr D	AA4444888
5/21/2021	6000	HDFC	Mr D	AA4444888
5/31/2021	7000	ICICI	Mr D	AA4444888
6/10/2021	8000	SBI	Mr D	AA4444888
6/20/2021	9000	Mirae	Mr D	AA4444888
5/11/2021	5000	Axis	Mr E	AA3333888
5/21/2021	6000	HDFC	Mr E	AA3333888
5/31/2021	7000	ICICI	Mr E	AA3333888
6/10/2021	8000	SBI	Mr E	AA3333888
6/20/2021	9000	Mirae	Mr E	AA3333888