Sum data from different sheets

Hello everyone,

Do you know how to sum values from different sheets into one unique value on one single sheet ?

In my business case I have 5 different clients and one sheet per client. For each client I have the amount of sales by month.

I want to have the total amount of sales on a 6th sheet that sum all my sales for each client per month.

I only see two options :

  • Make cell links in the 6th sheet for each client, and then make a sum children to have total
  • Make several formulas that go in each sheet and sum the sales, and then add all theses sums into one formula

Does anyone know if there is a better way of doing this ?

Thank you, have a nice day,

Corentin

Answers