VBA VLookup in Workbook with Multiple Sheets

[newlearner1]

I am trying write code for a Vlookup based on the current date in d-mmm form. I would like the code to search through each worksheet, there will be a worksheet for each calendar month, and return the value of different categories of disbursements. I am not sure how to do this and went searching on the web for something similar, and tried to adapt it, but I think my coding for the function is not correct, so I get an error.
I would like the values for each disbursement category and return them to the TestBook2.xlsm workbook under the disbursements tab.

If anyone could help, I'd really appreciate. I have attached sample spreadsheets and the code below:

Please Login or Register  to view this content.

[nathansav]

You can use INDIRECT to make up address based on text so

INDIRECT("'Sheet1'!$a$1") will give you the A1 cell for Sheet1, you can use these in vlookups to, so with yours

i'd use MATCH to find the column where the correct category is, and use INDIRECT("'July'!A1:b200") in my lookup.

[newlearner1]

so will i have to change the code each month with this: INDIRECT("'July'!A1:b200") and say "Jan", "Feb", "Mar", etc??
And I will need all of the categories on a daily basis....