Hi Experts,
Please I need help with VBA code to dynamically locate and copy the last values in column E before the errors and corresponding date in column A.

This is the amount highlighted in yellow i.e. cell E16 and in column A also highlighted in yellow i.e. cell A16 from tab "Q1" into tab "Summary". The values should be copied to cells C3 and C9 in the Summary tab of the same file.
In this instance the cell is E16 and A16 but this varies from customer to customer.
Below is a picture of tab Q1