Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of
the summary worksheet are linked to each of the indiv. company sheets. Each
code on the company worksheets is included on the lookup worksheet. I'd like
to have the corresponding mgr and rep data auto-populate to the summary
sheet.

The summary code cell link to the individual sheet is =ABC!$D$1. The
individual code cell link to the lookup is =Lookup!A2. B2 has the mgr data
and C2 has the rep data.

Your help is GREATLY appreciated!!!