The process in which a sterol regulatory element binding protein (SREBP) mediates an increase in rate or extent of transcription of nuclear target genes in response to sterol depletion. SREBPs are transcription factors that bind sterol regulatory elements (SREs), DNA motifs found in the promoters of target genes.