Usually, yes. Consolidating old workplace and personal pensions into one SIPP is one of the most common reasons to open one. However, some older schemes carry exit fees or valuable guarantees (particularly defined benefit pensions) that would be lost on transfer, so always take advice before moving a pension.
