如何从Excel中的另一个工作表链接数组

I am trying to use a formula to get values from one table column from another worksheet. I want to place the values in a single cell. I had tried using these formulas but it won't work:I am trying to use a formula to get values from