Need help how to setup code to create new sheets to a template based on a master sheet

I am pretty novice to the whole macro side of excel. I have a spreadsheet/ template set up. I would like to create a master sheet I enter in all my data accross multiple cells and have it auto populate to the template sheet and when the template sheet is filled have it create a new sheet and continue auto populating data and creating new sheets until all the data is populated. Attached is the template i was provided and the cells i would like to auto populate are A:19 -BC:40 I would need to know how to create the master sheet / how to get it to auto populate to those fields and then create a new page when those cells are filled up and continue on until all data is spoken for. Any help would be greatly appreciated.

Maybe I am wording this wrong but here is a new attachment. I am trying to get the data from the sheet called master to auto populate for the worksheet and once it reaches the bottom aka film ID no11 start a new page and continue with no12 and work down and keep creating pages and inserting data until all the data is inserted in order in the pages. How ever many pages it takes. Attached is the new spreadsheet im working with. I know how to autopopulate from one sheet to another like how its set up but the way I have it set up I would have to keep saving changing the formula and working my way down. And being this is an ongoing sheet that when done will have over 1200 entries would like to streamline it.

Ok so i have made some head way. I found some code that does kinda what i want to accomplish. The problem is its set up to only fill out 1 row of his template and then create a new page. I want my data to populate to the sheet and not create a new sheet until all 11 rows are filled out. Each row has different data going into based on all the parts im trying to record have a different serial number. But i cant get it to add multiple different items down my template. It takes my first serial # fills it the same down all 11 rows then starts a new sheet for the next one and so on and so forth. Here is a link to the code im working with. Any help on how to alter this to help would be greatly appreciated. https://sites.google.com/a/madrocket...-into-template