This is a multi-part request for assistance. I've cross-posted this
message between two newsgroups because I'm not sure which of the two
would be better to. Hopefully I have stated my concerns clearly!

Here goes nothing:

I have the following on Sheet1:

TAM ID NSN NOMEN
A0000 00000A 000-00-000-0001 Communication
A0000 00001A 000-00-000-1001 Comm Gear 1
A0001 10000B 000-10-000-0001 Comm Gear 2
B0000 00000B 000-00-000-0002 Engineer
C0000 00000C 000-00-000-0003 Miscellaneous
D0000 00000D 000-00-000-0004 Motor Transport
E0000 00000E 000-00-000-0005 Ordnance

And on Sheet2 I have:

TAM ID NOMEN

I would like to type or lookup any of the three criteria and the other
two be filled in automatically from the on Sheet1.

On Sheet3 I have the following:

ID Serial# OpStat

The ID should be a lookup from Sheet1 and OpStat should be a lookup with
the from the following table:

STAT DESC
AD Desc for AD
SD Desc for SD
CD Desc for CD
CL Desc for CL
RD Desc for RD
Note: This table is also found in Sheet1

When the user types or mouses over a status code (AD, CL, etc...) I
would like the description displayed for a few seconds.

Finally I'd like to group Serial#'s from different TAM to form a system.
For instance, Sheet4, Sheet5, and Sheet6 all have the same type of info
as Sheet3 identifying different equipment. However for training
Sheet3Row2+Sheet4Row17+Sheet6Row30 form a unique system. The OpStat of
any individual item automatically becomes the OpStat for all other items
in the system.

Thanks in advance.
Andrew