It will refresh automatically. If it isn't, then the data still exists in a different worksheet. Try the two that I suggested.
