Copy data then remove unused rows

So I gave the code you suggested a try and it does get the data into the correct location on the correct sheet, however it remove the formatting that is already setup. Is there a way to get it to put just the context into the cells and not the formatting? I have the formatting set up so it works for my accounting department.

I am also wanting the code to remove any of the unused rows at the bottom of the first sheet so that the signature lines move up and the page looks nicer without an blank rows in it. Can this be done?

I added 3 files to show what I am looking for.

Original = The main template
First code = What the first code does
Final = What I want the page to look like once the code is executed.

Thanks in advance for any help with this. My boss is hounding me about this project so I truly appreciate the assistance!