Lookup or Macro ? - Not sure which is best?

Hi,

In my work, we use spreadsheets which have the same content and repeat a lot.

The thing is that whilst the majority replicates, the content is not in the same position on each & every worksheet.

We have bills of quantites to price. The detail/description is provided in column A (and normally over approx 400 rows) and the pricing is normally covered in column D.

Each bill may have the similar detail/description in column A but it is NOT exact.

What I am trying to achieve, is to be able to use an already priced Bill as a template, then, use a Macro ? or Lookup? (or anything else that may handle the job) to identify the content in column A (in otherwords, match the detail/description), returning the price in column D, it having recognised that the content in say column A matches in the already priced bill and returns the correct price per item in column D.

I've attached a worksheet which will help explain better.

Thanks.