Cross sheet formulas referencing different columns


When creating a formula with cross-reference sheets, do all of the columns need to use the same source? For example, I would like the second part of the formula pull from 2 different columns, but when it's pulling from the same source. When I change the formula, it affects the others too; I get this notice.