I have a huge excel file

I was hoping to create a list on one tab.

When I click EMEA or America, I want the data & graph to appear.

I think I need to link the various data tabs to the one with the list box

How do I achieve this?

There's not enough information here to assist easily. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. (zip it up if necessary)

Add more information to your question when you attach a workbook in your next post.

I have tried uploading the file.

It is not very large, but keeps coming up as invalid.