Auto Refresh


Is there a way to set sheets to auto refresh? I have several reports set up for sheets, but will not refresh unless done manually.

Also, when sheet B is updated from data entry from sheet A, conditional formatting does not update on sheet B until manually refreshed.