Reporter who discovered Gary Barlow marks 40 years with publisher Journalist looks back on “rollercoaster of discovery and excitement”