How I can make a cell contact with another cell on another sheet and it will
changes when day changes.

example I have cell A1 sheet1 contact with cell A2 sheet 2 and cell A1 sheet
2 is the date when the date change A1 sheet 1 will auto change to B2 sheet 2
and the date = B2