Is there a possible way LINK a (formula table array) to a cell, that when
updated it shifts that formulated array to corresponding coordinates?

WORKSHEET 1: columns A,B,C,D

9/8/2006 9/15/2006
Item Item Item Item
Number Quantity Number Quantity
300482 162 300482 162
300485 2 300485 2
490806 73225 490806 72935
490808 10309 490808 10277
490810 109835 490810 109467
490815 32042 490815 31942
494003 55129 494003 50523
496900 1785 496900 1381

WORKSHEET 2: just the FORMULA

Number QTY
297102 =VLOOKUP(A2,'WORKSHEET 1'!A$3:A$10,3,0)

LINK: with in this formula I would like to incorporate a LINK the DATE from
(WORKSHEET 1) so if I change the date within a cell on (WORKSHEET 2) to read
(9/15/06) the formula will automatically change the array from (A$3:A$10) to
(C$3:D$10)