clear used area, then copy related fields if match is made

Hello. Please see attached file. This file will create customers if they do not exist and is a smaller version of the original so I left in the code of the original to help show what is being done. Manual changes to the 1_ImportedData and ZZ_Maintenance sheets need to be updated on the corresponding customer sheet and corresponding customer row on the 2_Summary sheets if they already exist.

So basically, I need the code to look to see if a sheet exists, if it does, copy the corresponding row of numbers from the ZZ_Maintenance to the customer sheet starting in D4, clear the used area starting in A5 on the customer sheet, copy the corresponding data from 1_ImportedData to A5 on the customer sheet, then copy the values from the customer sheet D1 and D3, E1 and E3, F1 and F3, G1 and G3 to the corresponding fields on the matching customer row on 2_Summary.

Thanks.

Attachment can be downloaded from the Forum here:

HTML Code: