Thank you first,
I am off to bed as this has taxes me for the last 8 hours !!!!! but I
know some one will give me this on a plate, if I can describe it;

1) I have a list of products and their unit value
2) I have a list of product ordered by site, this list is on 4 work
sheets (each with a range name), they are the same (difference is date
& product code)
a b c d e
f g h
i j
CCCODE| C No |Div |Reg |C Name | DESCRIP |ORDER_REF |DATE |UNITS |
UNIT_DESC |value

I am looking for a simple way to list what each site has ordered, by
product by value. The kicker is they may have ordered the same thing
multiple times, which apears on different sheets......


A little bit of VBA code would work.........................I Hope
'cos I can not make any thing else work


Help please I am stuck

Matthew