Summing Multiple Worksheets

[pdmny]

Here is an easy one...How do I sum multiple worksheets into a summary sheet. I have several copies of a sheet with input from various sources. I'd like to create a summary sheet that sums all values in the worksheets. For example, all values in cell D24 will be added together and displayed in D24 on the summary sheet. I can do it manually, but I'd like to know if there is a commande I can use to avoid manually summing.

 

[lenze]

Check out the Data>Consolidation feature