Google Sheets: Totaling multiple cells TO a single cell on a different sheet

I am a VERY basic Excel user and my issue relates actually to Google Sheets, but I figure it is probably a similar solution.

I have (or will have) multiple sheets which track transactions of various stocks and options. I want to total these to a summary on a separate sheet. (in a variety of ways)

I understand how to =SUM these, but want to do it in reverse, where the transactions on the sheets total TO the summary. This would not only avoid the really long formulas that I now have but allow me to build templates for the various 'sub-sheets'.

I have been unable to locate any help, so I would appreciate knowing if this is actually possible, and at least a point in the right direction, strategy-wise.

Thanks in advance.

Originally Posted by davesexcel

Possibly share a linked sample google sheet.

Thank you for the response. I had thought of including some kind of example but decided it was not realistically possible at this point out of privacy concerns. My question involves what direction I take in developing an already existing spreadsheet full of data.

As I mentioned initially, my goal is to track the income generated from dividends and option premiums. Currently, I am entering that data manually into a large table where each row represents a stock position with six columns per month for data entry, which are one column for dividends, and five weekly columns for option premiums.

This manually entered data totals (via the SUM function) to sub-totals for several accounts, then again to a sub-total for each month, then again to a current month total, and then to a YTD total. This all works.

What I would like to do, is move the manual data entry to a separate sheet, one for each stock position. In this manner, I could expand the data entry for each position easily, allowing me to better track the performance of each position.

The problem I am seeing is that I want to have a summary sheet, and using the SUM function would require very complex and ever-changing formulas.

So, my basic question is..... is it possible to have data from several sheets total TO a single cell on another sheet? In other words, the reverse of the SUM method. Instead of, as an example, cell D5 summing cell B6 of sheets 1,2,3,4...etc. (I currently have 27). Have cell B6 of each of these sheets total to cell D5 of the summary sheet.

This way, I could simply create a template for a stock position (since these change periodically) and not have to change the formula on each of the several cells on the summary sheet.