Hello

I'm trying to create a vlookup function that will search through multiple tabs of my worksheet.

I have a "master list" with compiled data consisting of vlookups.
Each vlookup looks for a particular client name from a different tab and then pulls the information.

However, the client name could be in one of 4 different tabs, and I can only figure out how to do a vlookup for a specific tab. Is there a way to have the vlookup look for the client name in all 4 tabs not just one?

Thank you