combo box linking to data

Hi, new to this forum.

wondering if someone could help by showing me an example to help me create a model.

the goal is to use the summary sheet and determine which subsiduary i want to view in a specific currency & then be able to compare to a number of differnent data such as previous year, years prior, budget, forecasts etc.

ive used combo box to create the dropdown menu's with lists.

ive created a very simple p&l & data worksheet.

question is how do i link the data to the dropdown lists and then how to automatcially update my p&l.

just need an example of it and i should be able to figure out the rest as in real life the p&l's are very long and tricky.

many thanks

Sorry know i shouldn't bump but if anyone can help id really appreciate it