Imagine in Excel you have A1 = 1

A6 = 2

A11 = 3

This is for this weeks data, next week value 2 could be in A7 or A10
or A12 etc.

I want to have the flexibility to fill down from e.g. this week from
A1 to A5 and fill A6 to A10 will a 2 etc.

How can I do this? I can't seem to get the range flexibility, thanks.