screenshot.1.jpg

Hi All!
Can you please help me write a script that does next:


Column A cells have dropdown menu of defined values that are found on SOURCE LIST tab.
I want range from B2:M2 to be copied to sheet S1 if from cell A2 "SOURCE1" is selected by drop down list, or copied to sheet S2 if from cell A2 "SOURCE2" is selected by drop down list and so on to S5.
THe same thing is with cell A3, A4, A5 as long as there is data.

So S1 will have all Source1 data, S2 will have all Source2 data and so on. It should be in the same order as added to main list without empty rows.
Also what are the options, can it be done automaticly or it needs to be triggered by a button?

Thank you very much