Formulas to update from different worksheets depending on drop down option chosen

Hello !

I could really do with some help.

I have a workbook that has a number of worksheets for teams to input their own performance data - this performance data will then be presented in another worksheet 'Report' (which I have linked to the 'Lettings' sheet at the moment).

Is there a way that if a certain drop down option is chosen the formulas will look at data in a different sheet??

So I would want formulas to be looking at the lettings worksheet if the lettings option is chosen from the drop down and then when the team 2 option is chosen from the drop down, team 2 worksheet is being looked at.

I have attached the workbook I am currently using.

Any help with this would be greatly appreciated - it's been driving me crazy!

Thanks

Thank you so much!! This works perfectly.

I really appreciate it!! :D you have made my day