Loop to find data in a worksheet and copy into a different worksheet.

Hi Everyone,

So yet again my lack of VBA skills is causing me trouble, even though i'm very sure it's the quickest way to do what I want.

I have a workbbok with 8 sheets

sheet 1- 7 are for customers, and contain details of the date they used a certain product and the amount they used
sheet 8 is the price of the product on any given day since the beginning of 2010.

what I need is for code to look at the date a customer used a product and then find the corresponding price on that date.
And copy that price into the customers sheet. column 3
I need this to loop until the end of the customers data and then move on to customer 2 ... 3 .... etc

I have attached a sample of the workfile for reference.

Any help would be amazingly welcome.

Thanks.