I have several worksheets that are used to input data into to a summary
worksheet for a golf league One of the worksheets is a schedule. The schedule
worksheet has 18 columns (one for each week) and the 32 rows have the team's
tee positions and opponents for that week. When the summary worksheets is
printed each week it has the current weeks schedule shown.

I would like to be able to have the current week's scheduled transfered to
the summary sheet by identifying the week number and have the data transfered
from the schedule worksheet to the summary worksheet. I tried the lookup
function, with the lookup value being the week number and the lookup vector
being the row with week1, week2,..., etc. and the result vector being a cell
in one of the columns. The problem with this is when you change input value
(week number), the lookup result vector does not change.

Any suggestion on how to best do this would be appreciated.