How can I analyze data from one worksheet and if it qualifies based on a
formula, move the customer name and other information to the next worksheet
to further analyze.

Example: Customer Qualification Process

Worksheet 1 asks for volume, sales and to rate certain criteria. If the
score meets a certain criteria, move that customer onto Worksheet 2 list as a
prospect. Then as a prospect further data is asked for, tallied and if the
score meets a set number, they become a target customer.

Any help would be appreciated...