hlookup multiple tables

[gandyling]

I was after a little help. Ive got 12 tables in a spreadsheet each one named after a month January to February. Each table has each day of the month in it and some names (lets Bob Fred and Jon).

On a another sheet I have a list of the names and in cell A1 it has the current date. Currently I use the following formula =hlookup(a1,january,3,false) with 3 being the persons name. Is there away to get the formula to look at all the months?