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