If Weekday Then Sheet

[unhorsedpenny]

I am looking to create a formula that takes the day of the week and calls for a specific sheet.

IE If it's Monday it takes the table from Sheet 2, if it's Tuesday it takes the table from Sheet 3 etc

For background I am creating a sheet for a schedule, if it's Monday then do this task, if it's Tuesday do this task etc. I have the tasks as separate sheets

 

[Toadstool]

Hi Unhorsedpenny,

This retrieves cell A1 from the appropriate sheet

=INDIRECT("'Sheet"&WEEKDAY(TODAY())&"'!A1")