Need help asap, how to show graph in main sheet with variable sources
 

Hi,

I currently have a workbook with 7 sheets.
One called Main and the other are named with the weekdays names
(monday-saturday)

Each sheet has on top a pie chart showing the number of fruit sold
(theres 4) and on the right to the graph I have several rows with
calculations like totals and stuff for this particular sheet.

I want to have on the main sheet the same graph and the info on the
right of the graph copied for the correct sheet.
Basically what I am asking is how do I make the rows reference the
sheet that matches todays weekday?
On cell A1 I have =weekday(now())
So instead of having on row p3, '=Monday!p3' something like
'=whatevertheweekdayis!p3'?
I guess it is the same for the graph source?

Thanks for the help.

Need help asap, how to show graph in main sheet with variablesources
 

Any ideas on this?