Probably the most efficient way to tackle Q1 is to have a reference table called say, menu, which is just a list of all the teams
Then use Hyperlink function to navigate to the worksheet of the same name eg =HYPERLINK("#"&A2&"!",A2)
Reason I would use the lookup list in column A us so you can use it as a variable in case it needed else where in the project
The above could equally be hardcoded for each team like so
=HYPERLINK(Arsenal!A1,"Arsenal")
You could also create a link on each teams sheet to take you back to menu
View attachment 95792
I think that is what you are after anyway
Question2, um where does the data come from and how is it updated/entered?
Many thanks.
In relation to Q2, I (labouriously) have entered all the data by hand from the Companies House website for all clubs for the last five seasons (or more for some clubs), so it is nearly all hard coded, although some figures are formula based.