need help on excel 2016 to filter the rows of data with different colored cells

Hi ,

Is it possible to extract the rows of data from multiple worksheets into one excel sheets.
For E.x., In excel sheet A there are 10 (5,6,7,8,9,10,11,12,13,14) rows with 4 (B,C,D,E) columns. where some fields are marked in some colors (C9,C11, D12,D13) like wise. and excel sheet B there are 25 (26,27,....50) rows and 10 columns (E,F,G,H,I,J,K,L,M,N)where some fields are marked in some color (F27, G30,I35 ...) Like wise.

Now my question is is possible to extract only the colored rows of data from multiple sheets into one sheets. In my case we have 65+ worksheets with different no of rows and columns in each worksheet.

Looking for some help.

Thanks,
Praveen G

In other hand, i need to color the column A cell if any of the subsequent column cells are colored . Sheet 1 may contain 10 columns sheet 2 may contain 15 columns .