Theory of scanning tunneling spectroscopy: from Kondo impurities to heavy fermion materials