Need macro to copy data from 1 sheet to multiple sheets based on certain criteria

So here is the promised walk-through of the macro used in your file, hopefully this makes sense to you or you could be more confused but now on a much higher level

Alf