I have a worksheet containing plant information. Each plant has a unique
code in column 1. The adjacent cells in that row contain information about
that plant (size, color, latin name, etc.)

When I create a list for a new job, I'd like to be able to input an existing
code in column 1 of a new worksheet (or even blank space in the existing
worksheet) and have Excel 2007 automatically fill in the adjacent cells.

Any help would be greatly appreciated.