Pull Data from Another Worksheet Automatically

Hello everyone:

I have an issue that I am looking for help with. I have a workbook, in which I will have approximately 5 worksheets. The 1st worksheet will be a summary table, which will pull data from the other 4 worksheets. These 4 sheets have data of 4 companies, thus representing 4 companies. In the 1st worksheet, I have a drop-down list that has selections for each company.

How do I make it so that when I change the selection from A company to B company, the data in the summary table will automatically pull data from corresponding worksheet? For example, if 2nd worksheet represents Apple Inc, the 3rd represents Microsoft, how do I reference from 2nd to 3rd worksheet automatically when I change my selection from Apple Inc to Microsoft in the 1st summary table sheet?

Thank you very much!

Sincerely,
Peter

Hi,

Choose your company from the purple cell, and then watch the value in the orange cell change accordingly. Is this what you're looking for?

I hope this helps

Yes ajryan88! Thank you very much! Now I get the idea of how to set it up, and am trying to apply this formula to my spreadsheet. If I have more questions, I'll let you know!

Thank you very much again!

Sincerely,
Peter

Excellent!

If you manage to make it work without any hassles, please don't forget to mark this thread as solved. And please also click on the * next to my post to say thanks and add to my reputation

Have a great day