Displaying the amount of the latest change to a cell

[sduttonusa]

I have dozens of worksheets under the general category of "Projects". There is a place in my workbook where I have a running total of the balance for all the projects. Is there a way to monitor the total Projects cell and display the amount (plus or minus) of the last amount that was recorded somewhere throughout the worksheets in Projects?

 

[Yongle]

thanks for your feedback