First make sure the target file is open and then try:

=INDIRECT(E1 & "Monday!C1")

I cannot test this. You may need your single quotes.