General Question/Advice

[mike0m]

I need some advice on how to tackle a particular project.

I have 2 excel files 1 file has data in a database type format. The 2nd excel file is a "template" that was created to take in the data from the first file.
My question is how can I make the template pull in the other data so that for every row there is a new worksheet is created with the completed calculations? Kind of like a mail merge in word. Pull the data create a report per row.

Any suggestions would be appreciated!

Thanks