Formula to display data from another worksheet whenever there is a new entry

Hello,

Thanks for the help!!


I have worksheet 1 - Expenses with table headers as Date,Description, Category, Amount and worksheet 2 - Summary. Whenever a new entry of expense is made in the worksheet 1 I want the new data to be reflected in worksheet 2.

Is there a formula that I can make use to automatically copy the data into worksheet 2 whenever there is a new entry in worksheet1?

Originally Posted by KOKOSEK

Or maybe instead of changing Wks2 at the moment of new entry in Wks1, you can update Wks2 (while opening) with actual data from Wks1?

How do I do that?

Thanks for the help