Sheet 1 has "100" in cell A1. If sheet 2 contains "100" in range A1:A10 I need it to delete that cell and adjacent cell (Shift cells Up)

Example:

Sheet 1 Cell A1 = 100
Sheet 2 Cell A4 = 100. Delete Cells A4:B4 and shift cells up

Thank you!!