Copy and Paste Value macro on multiple sheets

I have searched on the forum for an answer to my problem but cannot seem to find anything.

I have attached a example.

I have 3 sheets (GP, CT and EL), each sheet represent employees and hours. The amount of employees varies every month. I have formulas in row 1 which I would like to copy and paste value down for these employees. The formulas can be found in Row 1 columns D & E. I would like the formula to copy and paste value only to the last line which have a employee name in. The formula's in D1 and E1 I would like to keep so that I can use it to do spot checks.

I hope someone can help.