Hi,
let me first say i'm a very beginner with macros...i've set something up looking posts and forums around but i'm not skilled.
I would like to build a macro that searches within a worksheet all the cells with a specific color and paste the information of the coloured cells into another sheet together with the header of the column where the coloured cell is found and the value in a specific column in the same row

i attached the sample file
Basically the macro would need to find all yellow cells in sheet "Import Data" and copy them in sheet "Errors" together with the header in row 2 and the value in column A
can anyone help to guide me?