Good Afternoon;

I have a workbook that tracks the sale of the items in my store. The Main tab contains all sale requests for the day. Each day these items are either placed on hold, filled or voided. I have 3 other tabs each named Hold, Filled and Voided. I want to automatically move these items to each designated worksheet according to the action taken on each order. Example: Items placed on hold would automatically move to the tab labeled Hold etc. I have entered the headings below of the Main tab. Once the Action Taken column is completed with either Hold, Filled or Voided then I want it to be automatically copied to the first available row on the Hold tab.

Invoice Customer Price Product Quantity Action Taken

I hope I have explained this sufficiently and would appreciate any help I could get with this. I don't know how to write macros so I'm really depending on a good formula. Thank you in advance for your assistance.