Consolidating data in excel

Hi All,

I am trying to have a dynamic table which will automatically update when the user key in additional customer

Please see my excel worksheet

Any help is greatly appreciate. Hopefully not macro involve