I have sheet (A) receiving values from sheet (B) & I want to remove sheet (B) with all related formulas in sheet (A) e.g.

Sheet (A) include: if (sheet (A) cell (x)=y, sheet (B) cell (z),"")

So i want to remove the whole [value_if_true] & deleting sheet (B)

Thanks in advance!