Find filled cell in column, select corresponding rows and copy only selected cells/columns

I've searched for similar threads but couldn't find suitable one.

Macro that searches for filled cells in column A-starting at A2 (Sheet1), selects the corresponding rows and copies cells only in columns C, E, G and pastes them to Sheet2 starting in cell A2 to C2. At the same time it should delete previously found filled cells in column A (presented in Sheet1a) and colour them red, because I want the next loop to find only new filled cells in column A (Sheet1).
When it pastes it to Sheet2 I would need to find last filled row and each time paste it bellow.

Many thanks for suggestions!