Automating the filtering/copying process will require VBA (macros). You can do this yourself by turning on the Macro Recorder (Tools menu | Macros | Record new macro, and then doing all the steps manually. The Macro Recorder will turn these steps in VBA code (once you complete all the steps, turn the macro recorder off). Assign the code to a button – each time you update your data, click the button and the macro will perform the filtering/copying.
Alternatively, someone on this Board will write the code for you. However, you will need to provide a lot more information, preferably backed with a display of your data (use the HTML addin – see the download link at the bottom of this page). Information required includes:
Layout of the data, with examples, including the worksheet reference.
The layout of the order form, including the worksheet reference.