I want to pick 2 values at a time from a two tables like this (total 4
figures), situated on spearate sheets:

Sheet1 Sheet2 So: Formula = 2+7+4+6

WEXZ WEXZ

T T
E E
F 27 F 46
Q Q

Number of columns is subject to change. Number of rows is constant.
What is the least messy way of doing this?