I have a workbook with multiple worksheets. Each worksheet is dated with a
column of dates based on a two week work period. The dates within each
worksheet need to reflect that weeks work dates. How do I key the dates to
each worksheet without having to physically key dates to each worksheet?

ex.:
Date Arrival Time Departure Time
November 01 10am 2pm
November 02 10am 2pm