Macro which will copy entire ROW to another sheet based on contents of one cell!

Chris,
Data will always be transfered as they are entered as the macro proceed from the top down.
Now, in order to keep data in Main Iput and not transfer them multi times, the macro puts a "True" in column "L". Otherwise, the cells in this column are empty. When the macro copy a row into a tab, it will also write "True" in the L cell of this row. Only rows with L cells empty will be copied. Is that OK for you?

Now, about removing the scroll lock, the easy way is to program a macro with a password (Actually password is "Test"). I did it for you. In fact, I created 2 macros: One to remove the scroll lock and the other to reapply it. Both are password protected. This is not high tech protection as anyone can see the expected password by looking at the VB codes. But you can protect this also by a password by going into the VBA Project properties. Be carefull because this one is a real one. Make sure you'll remember it.
Hope this help
Regards