Since I'm seeing "new worksheets" and "change in customer name" (which I take
to mean a new customer name, I'm going to say that this can be done but that
it would have to be done with VBA code (a macro). I just did this very type
of thing for someone else here in these forums and what we did was to assign
a macro to a button that, when clicked, would either transfer the contents of
a particular row to a designated sheet (sheets were named with people's
names), or if it was a new person, then a new sheet was created and the
information transferred to it.
There are no worksheet functions to create new sheets in a workbook, so that
side of it alone requires VBA code to accomplish automatically.