A range of cells has multiple background colours. Depending upon the colour selected by an end user via a cell drop down, those cells (along with information in other columns) should get transferred to another worksheet.
You may refer to my solution in this workbook.