Loop through Worksheet and copy data into a templated worbook.

Hello, I'm looking for a solution to a problem I'm having with a workbook.

Could anyone help me in creating a macro that would loop through a specific workbook copy specific data (always the same cells), open up a template workbook and paste the copied data into selected cells, save the file as a specified filename (specified in a cell) into a specific location and then close the workbook. Then continue looping through the rest of the workbook. I've attached a smaller version of the Main file and the template for reference

I'm wanting to copy only a few specific cells from the main workbook into the template, such as:

I2 - C1
Z2 - C7
AA2 - C10
AB2 - C11

It's just the looping through the workbook and copying the selected data into the template and saving it as a specified filename that baffles me.

The blank spaces are necessary as they have formulas in for linking to other files, none of that info wants to get copied across though, just thought I'd say incase you though it looked strange.

Any help would be greatly appreciated