Using Function to call Woorbook Sheet

[Guest]

I would like to use WEEKDAY() to call a particular Sheet in a Wookbook. The
Sheets are called Sunday - Saturday and I have an IF statement that needs to
check for particular information on that sheet depending on what day it is.
Have it currently functioning but it is taking up way to much space. I am
unable to update my code with other functions that I need it to calculate
until I can figure this part out.

Code
=IF(OR(AND((TEXT(TODAY(),"dddd")="Monday"),(HLOOKUP(MOD(NOW(),1),Monday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Tuesday"),(HLOOKUP(MOD(NOW(),1),Tuesday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Wednesday"),(HLOOKUP(MOD(NOW(),1),Wednesday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Thursday"),(HLOOKUP(MOD(NOW(),1),Thursday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Friday"),(HLOOKUP(MOD(NOW(),1),Friday!$B$1:$BA$40,2))>0),AND((TEXT(TODAY(),"dddd")="Saturday"),(HLOOKUP(MOD(NOW(),1),Saturday!$B$1:$BA$40,2))>0)),"y","")

As you can see it would be much easier if I could just do
=IF (HLOOKUP(MOD(NOW(),1),WEEKDAY()!$B$1:$BA$40,2))>0)
but obviously that does not work.

Thank you in advance

 

[Frank Kabel]

Hi
try:
=HLOOKUP(MOD(NOW(),1),INDIRECT("'" & TEXT(TODAY(),"dddd") &
"'!$B$1:$BA$40"),2)....