Hi,
I am by no means an excel expert but I have a problem that I will likely lose sleep over until I find a solution.

I have a workbook with 4 tabs of data - each tab is set up the same with the same column headers.

I want to create a tab that will essentially search the other tabs and return rows of data based on criteria specified be selecting an option in a drop down menu. I have tried using the VLOOKUP function however I think this is too complex a situation for it. Pivot tables won't work either because I'm not trying to analze the data - I am simply trying to filter/seach the data and return all the information in a row as is. Essentially i need to autopopulate a table based on selected criteria.

How do I do this?

Thank you!

MRA