Look up data from multiple worksheets

Hi JimDandy

I have written a macro that does what you ask.

To run it press Ctrl+shift+Q

I have shown the effect of adding a couple of extra adapters onto the Adapters tab

Hope this is of use

Regards
Alastair