It's Close Banker, not quite giving the desired output.
To test,
Sheet1, one Yellow cell, ie value 55.
Sheet2, one Yellow Cell, ie value 44
Output on Sheet6 is 5 occurences of value 55 listed in Range A1:A5
and no value retrieved from Sheet2.
So Close I can taste it.