New Sheet from Template, then fill in specific cells with data from a separate sheet

[IrishPebbles]

I have a template that I need to populate data into from a sheet of rows containing that data. I want the sheet to be created, named to match a cell in a particular column, then the data from the row populated into the template. Repeat down the original data sheet until all rows of data have been copied to their own sheet from the template. It feels very similar to a mail merge operation if variables could be used in Excel. I need this done in Excel for reasons. I can use VBA, but am a novice. I can understand code a lot better than writing it, in general, but am fairly proficient at copying steps.

Is this something that can be done?

Thanks.

 

[IrishPebbles]

I've decided to go with a different solution, based on my research since posting. I'd still be curious if anyone has any thoughts, but realize my question is vague. Happy Excelling, everyone!