Roster Format: Populating an area from a list of Weeks...

So... I'm still learning A LOT about functions and formulas and all that and it's amazing and love it...

However the one thing I want to do to make a pre-made Managers Schedule simplified for printing isn't quite going anywhere.

Long story short (I have some notes in the file) - I've understood I needed neat data in columns generally to make lists easier, which count the Period/Week headers I have out (it took me ages to realise trying to remove the blank cells from the list were going to work at all with this setup). I've created a sheet that can be hidden to counter that issue, easy done. But now it's matching the Period - Week # to the potential VLOOKUP or MATCH or INDEX or all of the above, that I'm struggling with.

So question is... Is it doable and I just need the dozens of explanations I've read on here and tried over and over to be explained in a more simpler term... Or if I want to have the list provide me with the week selected's information, I need to use the hidden sheet to store a heap of information and then send it over to the page to populate the correct info where needed?

If it is the latter, what is the best way of doing it so that the functions and formulas required won't be slow in retrieving the information and "lag" for the lack of a better term right now on any computer it's worked on. Tables? Certain functions? Any information helps!
Cheers in advance,
Wayne