Create Multiple Workbooks in a particular format from a Table

Hi, I want to create a macro wherein I can create multiple workbooks in a particular format from the data from a master table in a excel workbook.

Image 1 shows an example of the master table



Image 2 shows the fomat in which data of each row is required in individual workbooks



I want the data from individual rows to be populated in this format in individual workbooks(equal to the serial no. of the table) for each row. Values which are not there in the table such as : 'ABC' 'CDE' 'Phone Owner' 'Phone User' etc to be constant as mentioned in the format. Also the Closing balance should be a sumtotal of the bill amounts of all the months mentioned.

I could really use some help on this from you guys. Thank you in advance.