Hello!

So I have been given a new task at work. I currently have a sheet comparing about 20 different companies income statements side by side in columns with about 30 rows each. I need to somehow create on a separate sheet, a summary page where I will have the income statement from our company constant and then have some sort of search function where I can type in the ticker symbol of each company and have it pop up somehow so I can just compare that company to our company on the summary page. I have tried lookup functions, filtering and can't figure it out. Please help me!!