Urgent help with lookup between 2 sheets

[beedistinct]

I have a sheet that has day-wise data. Each day in September has one tab and they are named as Setember1, September2 etc.

I wish to consolidate the data in a second sheet where there is a column with dates from 9/1/2011 through 9/30/2011 by using vlookup.

=VLOOKUP(R[-2]C,'[Website Stats.xlsx][B]September1'[/B]!R3C1:R18C3,3,FALSE)

I wish to dynamically change the sheet that is being looked up from September1 to September2 if the formula is on a row with date 9/2/2011.

Apparently, using Ampersand doesn't work. Please help.

 

[beedistinct]

Never mind! I resolved it using the INDIRECT function!!

=IFERROR(VLOOKUP(R46C,INDIRECT(R44C2&TEXT(RC2,"mmmmd")&"'!"&R44C3),3,FALSE),0)