Correct use of Xlookup/VSTACK Combo

Hi All,

long time lurker and first time poster.

I tried this using a youtube tutorial earlier but it never worked so wanted to double check that what i'm wanting is possible.

I have a worksheet with 6 tabs, one is the home tab and the other 5 are split into employee departments.

I need to pull the closing balance for each employee across the departments into the home tab (Column G is the value that I need it to return, column A is the lookup)

I tried Xlookup(A2, VSTACK(DEPT1 A:A, DEPT 1 G:G, DEPT 2 A:A,G:G)) included all departments in the formula but shortened for the sake of the post.

Any help is appreciated.