formula/Functions support in Excel

I am trying to create a daly calendar for my father... If the cell (c1:c2) has content on the weekly calendar (sheet 1), I want to to go to a specific cell (c1:c2) on the daily calendar (Sheet 2). If...