I would be most grateful if any of you can help me to figure this out:

I have two sheets. I need a formula that will copy numeric values of three cells (B,C,D) from sheet 1 when a corresponding cell (from column F) on the same row is selected. I then need these three values to be to be copied to sheet 2 starting at a cell selected by the user anywhere in either column E or K. The next set of cells copied from sheet 1 will insert on the next line immediately below it.

Similarly, I need to copy numeric values of three cells (K,L,M) from sheet 1 when a corresponding cell (from column O) on the same row is selected. I then need these three values to be to be copied to sheet 2 starting at a cell selected by the user on any row in either column H or N. The next set of cells copied from sheet 1 will insert on the next line immediately below it.

I've attached a workbook (with comments) as a sample of what I'd like it to look like.

Book2.xlsx

Thank you!