On Change working with cell address Excel

On Change Get cell address and paste value in another worksheet using same cell address. I have over 35 sheets that keep track of who is off with PTO, FMLA, and so forth.I have a main calendar that I would like to look at and see who is to be off on that day.