Hi,
for this either an advanced Macro is helpful or you have to create hyperlinks back to Master sheet. Hyperlinks can be used in many formats however and they can be titles of columns where the data from specific sheet is taken for an example so having many hyperlinks doesn't have to be a bad thing. Just learn how to make most of them
Hope to have helped you.
Rgrds,
Kristiina