Hi everyone,

I have a spreadsheet with multiple tabs (they're called MEX, BRA, VEN, PER, COL, CHI, ARG). On each tab, I have a list of companies on column "A" and a corresponing revenue of each company on Column "B". I need to have an avarage of a revenue per company on a tab I named MACRO, but the tricky part is that there aren't the same companies on all tabs. For exemple, I might have company X, Y and W on the tab MEX, but only company X and Y on the tab BRA, and a X,Y,W and Z on tab VEN, and so on and so forth. Obviously there are hundreds of companies on each tab so I can't use a simple Avarege formula, and the macro sheet must have all companies.

Can someone help me with the formula?
Thank you!