Generate sheets with template based on datatable

Hi

Suppose I have a data table in sheet 1 like this:

Name Gender Age
John Male 30
Sandy Male 35
Sue Female 30

In sheet two I have a report template like this

Name -
Gender -
Age -

Basically I want to found a way to to generate individual reports (sheets named after each person) based on each row in the data table.

What I think I can do is to give each row a serial number and use a Macro to generate reports in sequential order. After that I can use another Macro to save individual sheets as a separate workbooks, therefore completing the process of making reports based on a table using a template.

Does anyone have any suggestion especially with writing codes for the first part.

Thank you.

Thanks, this is exactly what I am looking for. I will have a try.