I am trying to auto populate part of a spreadsheet with info that is
currently in a different sheet.

Its an invocie spread sheet where I have to input muliplte alphanumeric
cells that identify the vendor, the kind of business they do, the ledger
number, etc. This info remains constant. The rest of the sheet is populated
with variables (invoice date, invoice number, amount, etc.)

I have all of the constant info on one sheet, and when I have an invoce for
a particular vendor, I then cut and paste cut and pastecutandpaste all the
constant info into the invoice spreadsheet.

The question is: Is there a way to easily auto populate this constant info
linked to a particular vendor?

Lets say I have 3 invoices on my desk. Sony, RCA, Aiwa.

Is there a way I could just type "Sony" in the sheet, and have the
unchanging data assoicated with that vendor populate the appropriate fields?
The go to my next line, type "RCA" and have it do the same?