Look up data from multiple worksheets

OK so I mis guessed the size of your problem I'm sorry. Alright!

I have now tested the updated macro on 300,000 lines and it works fine (OK so it gave my little laptop indigestion, but the macro worked)

If it seizes up your computer, let me know and I can re-do it so it uses less resources.

Hope this works ok

Alastair