I have a spreadsheet that contains many worksheets, each containing sales information for each day of the month, labelled 1, 2, 3, etc. I'm trying to create a daily summary report that will take information from a particular sheet and display it on a separate sheet. My non-dynamic formula is:

='28'!$C$32/1000

Where '28' refers to the sheet with the information for the 28th day of the month.

Is it possible to have Excel determine what yesterday's date was (i.e. 28) and use that in the worksheet reference portion of the formula? I'm trying to accomplish this all in functions rather than VBA or macros, if possible.

Thanks in advance for your help.
Dave.