I have data in my 5 sheets in the same work book.

Can vlookup command find the data from the 5 sheets.