Moving Current Latest Data To New Workbook

[Terry]

I have a workbook that has 31 worksheets one for each day of the month.
The data in the worksheet if filled in each day so that on day two there is data in sheet one and sheet two but nothing in the other sheets.
I need to bring the most current data from the workbook to a different workbook.
This must be done using formulas no VB allowed.
thanks

[Excel Fox]

Depends on how you have set up your worksheets. One way of doing this is with the help of the INDIRECT formula. The only thing is the workbook from which the data is being picked should be open in-order for the data to be displayed correctly.

So for example, =INDIRECT("'C:\Users\User\Excel Downloads\[ReArrUpdate.xlsm]Sheet"&(DAY(TODAY())-1)&"'!$B$3")