lookup for multiple instances across various sheets?

Desperate to find help with this one. Hopefully there's a lookup function for this. Here's the scenario: have 3 sheets, 1st sheet is assets, 2nd sheet is liabilities, 3rd sheet I'm looking for the assets and liabilities to parse into it for the specific entity I type in (say in cell A1 of the third sheet). Let's say in case it's Coca-Cola; would love to be able to have the 3rd sheet pull in all instances of Coca-Cola and its entire row of data from the 1st and 2nd sheet (all entities are in column A in the 1st and 2nd sheet; Coca-Cola appears a few time in both the assets and liabilities sheets and would need all instances from both to be brought into the 3rd). So in the occurrence an asset or liability is removed or added, the 3rd sheet will pick up the update accordingly and will always match what's current on the other two sheets. Example workbook below. Thanks in advance to anyone who can help.

Hi finance14,

Here is my quick stab at your problem.
I created a new worksheet called Lists so I could make a dropdown on sheet3 in A1,
I then made Sheet3 A1 a Validation List to dropdown
Then put code behind sheet 3 to fire the macro when dropdown changed. See code behind Sheet 3

Then wrote some quick code to look at sheet 1 and every row in col A that matched, copied it to Sheet3
Then did the same for Sheet2.

Code can be cleaner but should work. See if this example gives you a start.

There are many more ways to do this problem. See Advanced Filters or Auto Filter if the Code is too hard or slow.