I'm thinking it should be fairly easy.
So I have about 45 similar tabs, each with columns stretching to the right showing different periods (eg. P1 starts in cell C3, P2 starts J3, P3 starts Q3, etc.).
On the first tab, I created hyperlinks on the left hand side so that someone can click on...