Can't copy function from worksheet to another

I am unable to copy a function from one Excel spreadsheet to another.  My staff needs to use this formula on different incoming files on a regular basis.  

For example: Attached is a file containing a tab called "Function Sheet".  The function in COL B needs to be copied to COL K of the tab called "Orders".

The goal of the function is to extract a ProductID from the field Description.

Thanks for your help.
Copy-Formula-Problem.xlsx