Displaying Contents of different worksheets by selecting the name from dropdown

Hello able geniuses,

I am trying to work on a template, rather complex for now, but I'm hoping someone here will help me simplify things.

I have a master worksheet with other worksheets linked to it through a set of data (from data validation dropdown) such that when I select an option from the dropdown list, the master worksheet displays a worksheet relative to the selected option.

Find attached.

I want a situation where if I select "Loc A" for example, in cell A1 of the master worksheet, the contents of the master worksheet automatically changes to the contents of the worksheet bearing the name "Loc A Details" and so on for the other locations.

Please I need someone to help me with this. I will really appreciate your assistance.

Thanks,

Don Adeks.

Thank you nflsales for your prompt response, however, I noticed the following from the attachment you sent:
1. The dropdown on the master sheet could not be changed from "Loc F" to other locations.
2. Each of the worksheets will have different data (as against the name of the location you used), which the master worksheet will only display when the relative location is selected.
Thanks