Automate Excel Workbook with Macros

We have a excel workbook that we need to automate some functions within. We have set one worksheet as a 'data variables' page called 'details' that we wish to fill in and the second worksheet named ' Asset register' be built with the parameters of the details page. On the details sheet we need to input the following details and have them update the asset register sheet accordingly: Client address ( this must populate the register in the appropriate place as shown ) Installation Address ( as above ) Job completion date ( this must populate the 'Test Date' columm on the asset sheet) Engineer Detail ( this needs to insert the appropriate engineer details inc signature image into the asset sheet) Asset start number ( insert into 'appliance ID' columm and autonumber the subsequent lines below up to the correct number of 'asset total' The pages must continue to format into a A4 printable area as per the example attached) Asset Total ( needed for the above) Retest period (this must be automated into the 'retest period' columm for all asetts. Also this number will determine the 'Retest Date' by adding the '12' months to the 'Test Date') The 'status' columm must be set at 'Pass' initially for all assets on the register. This field must be a drop down box option on every line. If 'failed' is selected then the whole row must be changed from Black text to red