Heartfelt tributes have been paid to an 'amazing' and beloved man from Carlisle who died following a collision in Newcastle.