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

Hey JeteMc and Menem,

Thanks a heap to both of you!!!

I think my biggest issue - being new to formulas and functions that aren't as basic as an = sign or a =Sum here or there - is that I had no idea how to really start it all off, so thank you both for giving me the tools/formulas/ideas to progress!

So far from what I've looked at, both will be amazing assistance in me getting this done this year instead of what I thought would be in three if I was trying to do it myself!

[LIST][*]Menem - The little I've toyed with it, so far looks workable, thanks a heap for the help!

[*]JeteMc - I have spent a good hour or so going through your steps on how you used Power Query for the PQTable, it was the first time I'd ever touched that and although I wasn't able to successfully recreate that table knowing all it's steps, I'm happy to have tried!

Your setup is great too, but unless I missed something, it's not a automated formula . Those tables prevent the selected print week from updating if there's a change of shifts, or whatever else may happen.

After re-reading my initial post here, I apologise for not being clearer on that part too, as it's an important detail. Either way, I have learnt a lot from my play with the Get & Transform or "Get Data" as it says on my Excel. Thank you again!