$\Lambda$CDM Tensions: Localising Missing Physics through Consistency Checks