VBA coding to automate certain functions in workbook

Here is a very basic idea of what I work with.

Here are some of the things that I need:

Ultimately, i want a workbook that

1. on the first sheet, parts are logged once they come to us (basically, just a holding sheet for parts awaiting processing)

2. once a ship date has been put into the remarks column, they are removed from the first sheet and automatically put on another sheet (a master log to look back to and see everything thats been logged and shipped so far in that month)

3. each item that contains "Y" in the 2410 or TSN column is treated the same as other parts as far as once they are shipped, they are removed from the initial log list.
But once they are initially logged, they are automatically copied to another sheet just for these "2410" items as well as remaining on the initial log sheet until a date it put in the remarks column.


Once a date is put in the remarks column,
a. they are removed from the initial log
b. on the 2410 sheet, they are MOVED from the waiting section to another place, perhaps, on the same sheet that shows these 2410 parts that have been shipped and are not awaiting processing
c. they are also automatically copied to the master inventory (the third sheet where all other parts automatically go once they are shipped).

I can see that this may be confusing and I'm hoping that the workbook I have included could clear up some confusion.

Thank you