Sum up from different sheets multiple colomn (sumifs)

How do I Sum up in one sheet from different sheets of different multiple colomn's source ?

Please take a look at attached sample.

in sheet 1, take a look Channel A23, we want trace to to sum up that channel's Valid Transaction &Valid Revenue where it's coming from.

in sheet 2, take a look booking no IO-1610101510 which belongs to Channel A23 -> B43 & C10, so the Valid Revenueis at colomn B

in sheet 3, we know IO-1610101510 belongs from B43 & C10 (the channel -> sub channel must be in same row)

in sheet 4, we knows B43 & C10 are sourced in A23

in sheet 5, we can trace B43 & C10 Valid Transactions at colomn E


please give me the formula at sheet 1 for colomn B & C


thanks

I just want a formula in sheet 1 colomn B & C linking to each of all those others sheet

Originally Posted by Richard Buttrey

Please indicate the actual values you want for Sheet1 B3:C4. WHat do you mean by 'Valid' Revenue? Is that something different to the Revenue on Sheet2

-> Revenue from sheet


The obvious question is why don't you keep all your data in sheets 2-5 in a normalised database. Tell us how you use this workbook so that we can better understand your goal.

-> I retrieved from the source like so...

Originally Posted by Richard Buttrey

Hi,

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations. Consider whether the data might be arranged in a better layout.

Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

The aim is to get the numbers on the first sheet. How you do that is the question you're asking. Don't assume you NEED the other sheets you currently have since often a normalised database in a 2D matrix provides the most efficient solution.

I am sorry, I don't know how to put it as you were asking for...
the source is unknown, someone else got the source, i was just asked to help them do so...
so it's not me who actually even got it from a direct source