Pull different data from different sheets

[LinLindeloo]

Hi,

I have one workbook with 3 sheets and all sheets are same format but the data in each cell is different - how can I link each cell data from all three sheets adding them up together into sheet 3. 

example: D33 in each sheet will have different data and want to add sheet 1, 2 and 3 together in D41. Can this be done or am I wayyyyy out of my league in what I want?

Hope someone call help - thanks in advance.

Lin

[#2]

You can do that with a formula like this:

=SUM(Sheet1:Sheet3!D33)

This is called a 3-D reference. Read more about how it works here: https://support.microsoft.com/en-us/office/create-a-3-d-reference-to-the-same-cell-range-on-multiple...