Formula to get Week Number and Year(last, current and next)

I have 68 Columns, broken up into 3 sections by year
Columns A-H will have data from the last 8 weeks of last year
Columns I-BH will have data from the 52 weeks of this year
Columns BI-BP will have data from the first 8 weeks of next year

What I'd like to do is come up with a formula that will combine the weeknumber and the appropriate year. Ideally I'm gonna use this as a template for years to come so last year won't always be 2018.

Current formulas are:
COLUMNS A-H
="Week "&WEEKNUM(B6) through to AY6
Ideally I'd like it to say "Week 45 2018"


COLUMNS I-BH
="Week "&WEEKNUM('WFA BI - Daily Performance Rev'!BM6)&" "&TEXT(DATE(YEAR(TODAY()), 1, 1),"yyyy")
through to OY6
Ideally I'd like it to say "Week 1 2019"

COLUMNS BI-BP
same as columns A-H, with different cell references instead of B6
Ideally I'd like it to say "Week 1 2020"

I'd also like a macro that would jump to today's weeknum. It seems to work when I manually write "Week 1 2019" for example but the minute I put a formula in, it no longer worked.

Anyone have any ideas?

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thank you.

Perhaps this will help although it requires the user to select a hyperlink to the current week.
Row 1, which may be moved down the sheet and/or hidden for aesthetic purposes is populated as follows
1. Cell I1 =DATE(YEAR(TODAY()),1,1)
2. Cells H1:A1 =I1-7
3. Cells J1:BP1 =I1+7
Row 2 is populated using: ="Week "&WEEKNUM(A1)&" "&YEAR(A1)
Cell A6 displays the current week number using: ="Week "&WEEKNUM(TODAY())&" "&YEAR(TODAY())
Cell B6 displays the cell in row 2 that contains the current week number using: =ADDRESS(2,MATCH(A6,A2:BP2,0))
Cell C6 contains a hyperlink to the cell in row 2 using: =HYPERLINK("[Book1(Wheelie686).xlsx]Sheet1!"&CELL("contents",B6))
Let us know if you have any questions.