im trying to do the same thing. Except, my multiple worksheets are also in a
different workbook.

1. Is vlookup possible in this scenario?
2. If so, where does the workboook name go?

I've given it a go, but no success.