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.