Excel formula help

Copper Contributor

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? 

1 Reply

It very depends on how your data is structured and which summary you'd like to have. As variant that could be Power Query.