One cell linking to tabs, hyperlinks, etc.

[28creation]

Hi,

I've got a workbook that has the 12 months of the year & 10 members of a team.

Is there any way of filling in one box with a person's name & Excel will apply it to all relevant tabs, hyperlinks, etc?

It'll take a long time to fill in all the relevant information for each team, of which there are 8, otherwise.

Hope someone can help.

Thanks in advance.