Is there any update for Lightroom 5 to read the Canon 5D Mark VI raw format file at all please?
Before you say upgrade to CC this is not possible!
The only option apart from upgrading to LR 6 or subscribing to the CC Photography Plan is to use the free Adobe DNG converter.
It will convert the CR2 files to DNG files that can be read by LR 5.
Digital Negative (DNG), Adobe DNG Converter | Adobe Photoshop CC
You should probably also read this: Working with Canon Dual Pixel raw CR2 files in Camera Raw and Lightroom
Retrieving data ...