Ok I will try and explain it out.

So column A is customer then Column B is the service they need, either sales or repair.

Once sales or repair is type into column B, I am wondering if there is a way to use that as a key word that will upload their information into either a Sales or Repair spreadsheet based on the information typed into column B.

Is that any better?