union with multiple sheets

hi

anyone know a way of creating a union between ranges from 2 sheets??
because i have just found that union won't work as normal if you try this...

thanks

Jimmyp