Pull different data from different sheets

Copper Contributor



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.



1 Reply
You can do that with a formula like this:


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...