You can only import contiguous ranges with that function. So unless you had copied that union to a different sheet specifically for imprting, you cant.