Using SortBy and Filter (or similar) together with Structured References.

G-BullMetal To address the scenario, as presented, try either of the following:

=LET(
   arr, SORTBY(OriginalWorkbook.xlsx!MasterSchedule[CNC Order], OriginalWorkbook.xlsx!MasterSchedule[CNC Order]),
   FILTER(arr, arr > 0)
)

- OR -

=SORT(FILTER(OriginalWorkbook.xlsx!MasterSchedule[CNC Order], OriginalWorkbook.xlsx!MasterSchedule[CNC Order] > 0))

Having said that, it seems like you may want to include additional columns in the final output. If so, try something along these lines with the CHOOSECOLS function...

=LET(
   arr, SORTBY(OriginalWorkbook.xlsx!MasterSchedule[#Data], OriginalWorkbook.xlsx!MasterSchedule[CNC Order]),
   CHOOSECOLS(FILTER(arr, CHOOSECOLS(arr, 2) > 0), 1, 3)
)

-- OR --

=CHOOSECOLS(SORT(FILTER(OriginalWorkbook.xlsx!MasterSchedule[#Data], OriginalWorkbook.xlsx!MasterSchedule[CNC Order] > 0), 2), 1, 3)

Note: in these examples, I assumed the [CNC Order] column was column 2, and I chose to return columns 1 and 3 only. Adjust the column numbers accordingly to meet your needs.

Also, please be aware, Excel has limited support for dynamic arrays between workbooks, and this scenario is only supported when both workbooks are open. If you close the source workbook, any linked dynamic array formulas will return a #REF! error when they are refreshed.