I need to reference sheets with names that are dates, but cannot get formula to work!

[Dnk_83]

I am trying to set up a summary sheet using INDIRECT reference on a dropdown. The issue is that the sheets are dates and the formula stops working . i believe it is due to the date referencing and have tries to use the TEXT function, but still not getting it to work. Please let me know where i have gone wrong and what i can do to fix it!

The dropdown list is from a dynamic list that is a list of all the tabs and when the cell is selected the formula bar shows "dd/mm/yyyy", I changed the date format to "mmm-yy". Thanks.

 

[RoryA]

The names have spaces in them so you need to enclose them in single quotes just as you would in a formula - e.g.

INDIRECT("'"&TEXT(b3,"mmm yy")&"'!A3:E201")

 

[Dnk_83]

that is annoying how easy it was to fix! Thanks!

 

[RoryA]

Glad we could help.