Ref format

Ref is set to: {Client Reference} - {Job Title} - {Client - Final} {Site - Final} {Section - Final}

Fetch all live vacancies, review the proposed Ref for each row, edit if needed, then approve and update selected.