Generating Reports Automatically

Hi,
May be with pivot table report
First assembly the data in one sheeet with a column for subject
Insert a general pivot table with name in the report filter
In options of pivot table > options > display pages of report filter > for name
This will create automatically one sheet report per name
Hope this help
Best regards