I am working on a project right now that I need to automatically
update based on a report that I run every month. Here is what the
report looks like right now.

SalesRep CompanyCode Number Cost
Spread Margin File Avg
AUTR 1 94 $27,023.67 $9,114.65
34.9% $96.96
AUTR 2 41 $10,114.17 $4,875.64
34.9% $118.92
AUTR 3 21 $3,136.23
$1,254.64 34.9% $59.74
AUTR 4 1 $1,750.00 $416.00
34.9% $416.00
AUTR 5 1 $1,550.00
$219.81 34.9% $219.81
AUTR 6 17 $2,865.36
$346.82 34.9% $20.40
AUTR 175 $46,439.43 $16,227.56 34.9%
$92.73
AYLE 1 15 $22,400.00
$5,165.69 25.3% $344.38
AYLE 2 16 $11,575.00
$2,601.70 25.3% $162.61
AYLE 3 15 $9,942.50
$2,045.75 25.3% $136.38
AYLE 4 2 $3,900.00
$1,810.00 25.3% $905.00
AYLE 5 6 $4,880.00
$1,686.73 25.3% $281.12
AYLE 6 96
$104,862.50 $26,509.50 25.3% $276.14
AYLE 150 $157,560.00
$39,819.37 25.3% $265.46

There are 7 colums and 7 rows associated to each salesperson. The
final row is the total for that salesperson for the entire month. What
I would like is to be able to link the worksheets together and return
each corresponding line of information.

The formula I am using now is
=VLOOKUP("autr",'[top carriers.xls]Sheet1'!$A$1:$K$434,{2},0)

This works fine to get the first line of information, but my problem
is that I can't get the last 6 rows of information for each
salesperson. Anyone have any ideas that could help me? I really need
it to be able to automatically update everytime the top carriers
worksheet is updated. Thanks for any ideas you can come up with.
Anything is better than what I have now.