Hi,
I am working on a large number of sheets, each of them represents each date's report. In one sheet (named as database) I make a table with a list of dates.

I want to obtain data in a cell of a sheet as pointed by the date in that list. The problem is when I used INDIRECT, it gives #REF warning.

My cell which I want to get the information is also not a constant (contain SUM formula). Any suggestion?

Any help would be appreciated.
Iksan