Ok, I usually can get around problems with formulas, but this one is
beating ym brain to a pulp.

Anyone knows how to make the following happen?

Using sheet1, I want to transfer the entire line of text to another sheet,
using my customer names. That way, I can keep track of who ordered what
and when, and how much was paid for it, instead of jumbling it on one
sheet. The process would have me creat about 15 different sheet to track
my customer's activities.

Than you