How can I make the Table_array in VLOOKUP function dynamic moving between series of data?

Hi,

My question, how can I make the Table_array in VLOOKUP function dynamic?
Example:

for this formula in Cell D19
=VLOOKUP($E$2,Sheet1!$C$2:$M$7,2,FALSE)
Cell D20
=VLOOKUP($E$2,Sheet1!$C$8:$M$13,2,FALSE)
Cell D21
=VLOOKUP($E$2,Sheet1!$C$14:$M$19,2,FALSE)

what is the formula that I can use to replace the numbers 8 and 13 in Cell D20, and the number 14 and 19 in Cell D21??

Since there are NO bookings in April, (TODAY)... the grid should all have been blank.

There is no need for the lower Table. I changed the date in D5 to 1st February and used this in D6, copied across and down.

=IFERROR(INDEX(Sheet1!$D$2:$M$121,MATCH(1,INDEX((Sheet1!$C$2:$C$121=$E$2)*(Sheet1!$B$2:$B$121=Sheet2!D$5),0),0),MATCH($C6,Sheet1!$D$1:$M$1,0)),"")