WP_Query with MetaQuery issue

You may want to try adding the 'RELATION' => parameter into your meta query array so that you can encompass all of your meta values. Something like this:

    $v_args = array(
    'post_type'     =>  'loads_available',
    's'             =>  "Post Name", 
    'meta_query'    =>  array(
      'relation' => 'AND',
      array(
            'key'     => 'type_of_load',
            'value'   => "Frozen",
            'compare' => '=',
          ),
        array(
            'key'     => 'number_of_pallets',
            'value'   => 2,
            'compare' => '>=',
            'type' => 'NUMERIC'

          ),
        array(
            'key'     => 'type_of_trailer_required',
            'value'   => "Trailor",
            'compare' => '=',
          ),
          // ^ problem
        array(
            'key' => 'euro_pallets',
            'value' => "Yes",
            'compare' => '='

            )
        )
    );

    $loadsAvailableQuery = new WP_Query( $v_args );

Depending on your use case, you may need to set up a variable based on the user query to toggle the relation parameter in your query.

Note the relation parameter can also be set to 'OR'.

Checkout the meta_query section inside of the WP_Query codex