Formula to deliver to a different workbook

I am using the formula =FILTER(A2:A20,E2:E20>=1,"NODATA") in order to deliver data from column A to column E of the same sheet, excluding zero results.  Is it possible to write a similar formula in a second workbook sheet in order to deliver exactly the same results to it from this sheet in this first workbook? If I put = in a cell in a second workbook then click on the cell in the first workbook containing the above formula and hit return it only delivers the face value of that cell, not the formula's results. I can get all the results by clicking the down arrow at the top of the column containing the cell rather than on the cell itself, but that takes up the entire column with zeros delivered for infinity below the formula results rather than just the neat array the formula delivers in the sheet in the first workbook. I want to get just that neat array in the second workbook. Is there a way I can do that?