If the order form is hard copy, just type in the information.

If the order form is in a file, let Excel read the file in --- the Help
files will tell you how to read in a file that is not in .XLS format. (For
example, a file that is in .CSV format.)

If the order form is in a database, then you have to let Excel query the
database. The Help files will tell you (sort of) how to do that.

Without a good bit more detail regarding the exact nature of the challenges
confronting you, that is the best I can do.

I hope this helps.

--- BBQDad

--
"A little learning is a dangerous thing..." ----- A. Pope