Select a specific worksheet based on cell value and then populate information to the selected worksheet.

[J15491]

I have a workbook with worksheets titled Register, Utility Report, Rent and Utility. I'm new to VBA coding, so I'm not sure how to code this. In the register I enter information regarding a client I give assistance to for rent or utilities. In cell D4 to cell D30 I can select Rent or Utilities. So, if cell D4 value is Rent, then I want the information in row 12 to populate to the appropriate cells on the Rent worksheet and print 2 copies of the selected worksheet; in this case Rent. Once printed I need the option to print again or no. If no, then clear the information on the Rent or Utility worksheet. If information is entered in the next line of the Register I need it to repeat the same operation. Just way to complicated for me. I don't see where I can upload the workbook