Macro to copy a sheet/template in a based on numerical cell value or list

Hi All

I have designed a template to use for reporting purposes for individuals in a company - at present I am doing this by manually copy pasting the template into a sheet based on the number of people I need to report on. Is there an easier way to do this or macro?

After the template has been copied multiple times I would then need to provide individual performance discussion for each so mail merge is out I feel

For example copy and populate a template located in a sheet (say sheet 2) to multiple sheets (or multiple templates on one sheet) using a list of names - this can either copy and set up the correct number of templates based either upon a number of names entered in a cell / or from a list of names in a list located say in sheet 1

Hope this makes sense and I hope someone can help - thanks for your time

Cheers

Hodda