Output file to include all pivots/other tab in output files with Date id in it

[tsingh4]

HI

I have a report, which has data tab that stores raw data and multiple pivot and other tabs. This report has information for 50 managers, now I want to create output for each manager keeping all same pivots and others tabs.

Currently, I created a output file name using formula tool and selected take filename from field. All it does is create file for each managers but with Data tab only, I want whole report to be copied over with data pertaining to each manager.

[AndrewSu]

@tsingh4 , could you please provide a sample of the data file you are working with as well as an example of the desired output?  It is hard to visualize exactly what you are looking to do.