Hello Group

I know you are all busy people so thanks for taking the time to help!

I have a workbook that basically generates manifests for pallets - customer
address and product details. The user is presented with various userforms
that captures data and writes the information to a temporary sheet. The
various controls are linked to a cell reference and then once an Okay button
is pressed a macro then copies the information to a destination cell where
everything is made pretty. I know I'm duplicating the work but can't figure
out how to copy information straight into the pretty cells. For instance;
if a
new customer needs to be added to the customer dbase:

Userform2
(information written via linking to the temp sheet)
Okay button
(Macro find first empty cell, copy and paste the values to the pretty sheet,
sort the customers, clear original information and return control to user)
Userform1

I am only up to customer 20 and the macro has slowed considerably. Would I
be better off using external data source for customers?

Thank you
Mark (In Wales)