How to reference a spacific cell in multiple saved excel files.
 

I have an excel file for each day of the week with certain different values.
I need to pull a value from cell "C36" from each of the saved files. I need
to put these values in a separate excel file containing only the date and the
value of cell C36 for each date.