Making a vlookup search across multiple worksheets in a workbook

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

The client name could be on one of the four different tabs. Do you know how I would go about doing that? Thank you!!

Does anyone know how to create a vba code that searches for client names across 4 different sheets and then pulls the corresponding information from the matched client name?

Like a v lookup but across 4 sheets instead of just one sheet.

Thanks!