1st day i have to update Sheet 2, range a1:a200, and find ouf if this values matches the values

on Sheet 1, range a1:a200, if match found, i will write Y in day 1, if not i will write N.

day 2, i will again update Sheet 2, range a1:a200, and find out if this values matches from sheet 1, range a1:a200,

if match found, i will write y on day 2 column, if not, will write N... so on and so fort...

Sheet 1

Data1 | day1 | day2 | day3 |

AAAAAA | Y | ||

AAABBB | N | ||

AAACCC | Y | ||

AAADDD | Y |

<tbody>

</tbody>

Sheet 2

AAAAAAA |

AAACCC |

AAADDD |

<tbody>

</tbody>

Any suggestion how to solve this problem, in just a click?