I have a list of week numbers and I need to be able to put a week# and the next columns will automatically capture the next 5 weeks. So next 5 week # will be based from the first week # value.

Input Value changes when h3 value changes
WC0105 WC0112 WC0119 WC0126 WC0202

WC0112 WC0119 WC0126 WC0202 WC0209


Week
WC0105
WC0112
WC0119
WC0126
WC0202
WC0209
WC0216
WC0223
WC0302
WC0309
WC0316
WC0323
WC0330
WC0406
WC0413
WC0420
WC0427
WC0504
WC0511
WC0518
WC0525
WC0601
WC0608
WC0615
WC0622