I have a workbook that consist of 30 sheets. The last sheet is a summary of the date on the previous 29 sheets.
How do I set up a formula that will automatically transfer data from sheets 1-29 to sheet 30 as I enter ea day?
It very depends on how your data is structured and which summary you'd like to have. As variant that could be Power Query.