With some help from the guys on the WP forum I managed to get this working. I have shared the code below incase anybody needs it in the future.
<?php
$field = get_field('CUSTOM_FIELD');
if ($field) {
$file = $_SERVER['DOCUMENT_ROOT'] . '/files/' . $field . '.php';
require_once( $file);
}
?>